Table Configuration → Configuring Tables for Applications → Viewing and Configuring Fields → Viewing General Field Properties → Viewing General Field Information for Multi- and Single Relational Fields
General field properties are set in SBM Composer. The follow table describes those properties for Single Relational and Multi-Relational field types.
Field Property | Description |
---|---|
Table |
Indicates the primary or auxiliary table that contains the values to associate with the table or workflow with which you are working. |
Logical Field Name |
Indicates the name of the field as it appears to users. You can change this name in SBM Composer. |
Database Field Name |
Indicates the field name as it is stored in the database. The database field name cannot be changed or removed. |
Description |
The text entered here is displayed to users who hover the mouse pointer over the field name and in a help window users can opens from forms. |
Spans Entire Row on Forms |
If selected, this check box indicates that the field will appear on a single row on quick forms. If this check box is cleared, the field appears with another field on a row. |
Appears in Report Field Lists |
When this check box is selected, the field is included on report forms. This enables you to simplify field lists for users who are creating reports. Depending on the type of field you are creating, when the Appears in Report Field List check box is selected, the field appears in the Field Specification, Select Columns to Display, Add Columns of Calculations, and Sorting lists on report forms. The field is also included in the Row and Column lists on Distribution reports and the Trend lists on Trend reports. By default, the Appears in Report Field List check box is selected. In addition, if a field is used on a report and the Appears in Report Field List check box is later cleared, the setting is ignored for that report. |
Appears on Relational Field Value Lookup |
If this check box is selected, the field is added
to the Manage Data search form in
SBM Application Administrator
and the Relational Field Value Lookup form.
Tip: The field order for the Relational Field Value Lookup
form is determined by the default field order of the table's first project in
the project hierarchy. To display fields in a different order, add another
project to this hierarchy, clear the
Allow New Items to Be Submitted check box, and drag the project
to the top of the hierarchy for this table. You can also remove all user
privileges for this project so that the project is only used to determine field
order for search forms.
|
Allow Searching |
This option enables Value Find and Relational Field Value Lookup capability for the field. Value Find allows users to enter search criteria, such as an entire word, a few letters, or an asterisk, and then click a search icon or press Enter to perform the search. Results appear in a list, allowing users to select a value for the field. Relational Field Value Lookup provides an advanced searching mechanism that enables user to find values for Single Relational and Multi-Relational fields. If enabled, an additional search icon is available. |
Fully Populated List |
This option allows users to select a value from a fully populated list rather than search for values. |
Copyright © 2001–2019 Micro Focus or one of its affiliates. All rights reserved.