Viewing General Information for Sub-Relational Fields

General field properties are set in SBM Composer. The follow table describes those properties for Sub-Relational field types, which allow access to additional fields in a related primary or auxiliary table. Sub-Relational fields are tied to a Single-Relational field already in a table or workflow. For example, if an Incidents workflow contains a Single-Relational field to the Issues table, you can include a Sub-Relational field of Owner. This enables users to view the owner of a related issue within the incident.

Field Property Description

Relational Field

Indicates the Single Relational field associated with the Sub-Relational field.


Indicates the field from the Relational field table whose value will be displayed on forms.

Logical Field Name

Indicates the name of the field as it appears to users. You can change this name in SBM Composer.


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. 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. 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.