Applications → Managing Fields → Field Settings → Field Property Editor → Options Tab of the Field Property Editor → Sub-Relational Field Options
Sub-Relational fields allow access to additional fields in a related primary table or auxiliary table. Sub-Relational fields are tied to a Single-Relational field already in an application.
For example, if you have an Incidents table that contains a Single-Relational field to an Issues table, you can include a Sub-Relational field called Owner that users can use to view the owner of a related issue within the incident.
Values
Select the Single Relational field that you are associating with the Sub-Relational field.
Select the field from the Relational Field table whose value you want to display to users. For example, you could create a Single Relational field from a Companies table, and then create two new Sub-Relational fields: Company Address 1 and Company Phone Number.
Display
Select this option to make this field the only field to appear on a single row.
Search & Query
Select this option to include the field in lists on report forms.
See General Tab of the Field Property Editor for related information.
Select this option to add the field to the Auxiliary Data search form in SBM Application Administrator and the Advanced Lookup Tool and Relational Field Value Lookup forms.
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.
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.
Copyright © 2007–2015 Serena Software, Inc. All rights reserved.