Configuring Fields → Field Types and Settings → Single Relational Fields
Relational fields are used to establish relationships between data in primary and auxiliary tables. Single Relational fields allow users to select a single item from a primary or auxiliary table as a value for the field.
For example, you could create a relationship in a primary table used to track defects to knowledge base articles in the Problems table. While users are entering information about a defect, they could select a problem record that is stored in the Problems table. This enables users to see information in the Problems table while they are working with items in the primary table.
Single Relational fields are defined in SBM Composer. Use the Manage Data feature in Application Administrator to add values for Single Relational fields based on auxiliary tables. Values for Single Relational fields based on primary tables are created by users as they submit items into projects.
The Allow Override check box is automatically selected when you modify attributes and value and display options when you are adding or editing a project.
You can override the following Single Relational field attributes for default fields in projects and transition fields. Attributes set for fields in the Default Fields list apply to all transitions; attributes set for fields for a transition apply only to that transition.
Indicates that users are required to provide a value for this field. If a value was previously set for the field, the field label appears in green, italic text on forms.
Indicates that the field is available when users mass update items in a project. Mass updates allow users to simultaneously transition, update, or delete multiple primary items and to simultaneously update or delete multiple auxiliary items.
Indicates that users can view but not edit the field.
You can override the following display options for default fields in projects and transitions fields:
Indicates that the Value Find feature is enabled for the field on submit, transition, and update forms. This allows users to enter to search for values.
Enables users to select one or more values from a list.
The field's default value, if applicable, is selected. You can change this value as needed. Possible default values are determined by the active records in the relational field table listed on the General page for the field. For example, if the relational field table is a Customers table, possible default values are customer records in the table.
Select to retain the field's current value when the transition is complete.
Select to clear the field's current value.
Select to use a default value for the field as the user executes the transition. You can then select a default value.
Copyright © 2007–2018 Serena Software, Inc., a Micro Focus company. All rights reserved.