Multi-Relational Field Options

Multi-Relational fields let users select one or more values from a different table to associate with the current item.

Style

• Allow searching

  Select this option to enable the value find feature for the field on submit, transition, and update forms. This enables users to search for values.

  Tip: If the field will contain 200 or more selections, this option is recommended to ensure best performance. If you do not allow searching, fields that contain over 250 selection values are automatically set as searchable in the Editable Grid.
• List display size

  Specify the number of items that should be visible, without scrolling, in the list box for this field. This should typically be the number of expected values. If the number is too small, scroll bars are added to the list box, and with the List box option, dual list boxes are also presented. This option is unavailable when the Checkboxes option is selected.

  Note: This option is not used in SBM Work Center, where all list boxes are displayed side by side on submit, transition, and update forms.
• List box

  Select this option to let users select one or more values from a drop-down list populated with selections added to the Relational field table.

• Checkboxes

  Select this option to let users select one or more check boxes.

Values

• Application

  Select the application containing the table of values with which you want to populate this field.

• Table

  Select the table containing the values with which you want to populate this field.

Display

• Span entire row on forms

  Select this option to make this field the only field to appear on a single row.

Search & Query

• Appears in report field lists

  Select this option to include the field in lists on report forms. If you clear this option after the field is used in reports, the changed setting is ignored for those reports and the field is still shown until it is removed from the report definition.

• Appears on lookup form and relational field value lookup

  Select this option to add the field to the Auxiliary Data search forms and the Advanced Lookup Tool and Relational Field Value Lookup forms.

  The field order for the Advanced Lookup Tool and Relational Field Value Lookup forms for primary items is determined by the default field order of the table's first project in the project hierarchy. Projects are defined in Application Administrator.

• Appears on searches for this table

  Select this option to specify that the field will be available for selection on the Advanced Search page. This setting applies to primary and auxiliary tables. This option also adds the field as a facet for searches against a single application in SBM Work Center. See Configuring Advanced Search for additional information.

• Inactive items appear in selection lists

  Select this option to specify that inactive items will be included in lists on transition forms and report forms.

• On lookup or query-at-runtime forms
  • Allow searching

    This option enables the value find and relational field value lookup for the field. (See Allow Searching under Style above for a description of the value find feature.) The relational field value lookup feature provides an advanced searching mechanism that lets users find values for Single Relational and Multi-Relational fields. If this option is enabled, an additional search icon is available for the field.

  • Show full list

    This option lets users select a value from a drop-down list on the Lookup form of the Advanced Lookup Tool, the Relational Field Value Lookup form, and Query-at-Runtime forms for reports.