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

• Relational field

  Select the Single Relational field that you are associating with the Sub-Relational field.

  Note: Selecting a relational field enables the Sub-Field control.
• Sub-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.

  Note: This control is unavailable until a relational field has been selected above.

Display

• Span entire row on forms

  Select this option to make this field the only field to appear on a single row.

Search & Query

• Appears in report field lists

  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.

• Appears on lookup form and relational field value lookup

  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.

• On lookup or query-at-runtime forms
  • Allow searching

    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.

  • Show full list

    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.