Multi-Relational fields allow users to select one or more items
from a primary or auxiliary table as values. This associates items with a
particular table or workflow.
For example, you can create an auxiliary
table that stores versions of products. You can then create a
Multi-Relational field in a primary table that tracks data
related to customer-reported defects, and set the versions table as the
relational field table. This allows users to select multiple product version
numbers for each defect being tracked.
Multi-Relational fields are defined in
SBM Composer.
Values for
Multi-Relational fields are created in the Manage Data feature
available in
SBM Application Administrator
In
SBM System Administrator, you can specify default values for these fields for
auxiliary tables.
The following properties are defined in
SBM Composer,
except for default values:
- Default Value
— Indicates the pre-selected values for the field. The possible
default values listed are populated from items in the primary or auxiliary
table selected from the
Table list on the
General tab of the
Edit Fields dialog box.
- Load All —
If the
number of items in the Relational field table exceeds the number specified in
the
Searchable Field Values option located on the
Display tab of the
Settings dialog box, the
Load All button is available. Click this button to receive a
caution message about the number of items contained in the Relational field
table. If you click
Yes on the message pop-up, the list is fully loaded. If you
click No, the list is not populated.
- Allow Searching — Enables the
Value Find feature for the field on submit, transition, and
update forms. Users can enter search criteria (an entire word, a few letters,
or an asterisk) and then click search icon or press
Enter to perform the search. Results appear in a drop-down
list, from which users select a value for the field. This option also enables
users to search for values in the Rich Editable Grid.
Tip: If the field will contain 200 or more selections,
this option is recommended for 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 Box — Enables users to select one or
more values from a drop-down list.
- Check Boxes — Enables users to select one or
more values from check boxes populated with selections listed in the Selections
area.
- Height of List Box
— Indicates the number of rows that display values for the field
on forms. You can set the number of rows to display as appropriate for the
number of expected values for the field. This option is available for the
List Box and
Allow Searching options.
Note: If the number of selections exceeds this value, selections are
displayed in a dual list box instead of a single list box. However, this option
is not used in
SBM Work Center.
All list boxes are displayed side-by-side in submit, transition, and update
forms in
Work Center.
Copyright © 2001–2019 Micro Focus or one of its affiliates. All rights reserved.