Applications → Managing Fields → Field Settings → 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. 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.
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.
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.