System administrators can configure reference qualifiers that enable filtering of the associated reference field.

About this task

This task walks you through creating a reference qualifier in the system dictionary. When creating a reference qualifier in the system dictionary, it not only applies to that table, but also to all the children of the table.

Note: You can also create reference qualifiers on extended tables through dictionary overrides. Dictionary overrides only impact the extended table and any of its children, not the parent table.

Procedure

  1. Navigate to the reference field on the form or table on which you want to define a reference qualifier.
  2. Right-click the reference field label and select Configure Dictionary.
  3. Under Related Links, select Advanced view.
    The simple reference qualifier is available in both the default view and the advanced view. The dynamic and advanced reference qualifiers are available only in the advanced view.
  4. In the Reference Specification section, verify that the table in the Reference field contains the table that you want associated with the reference field, or select another table if necessary.
  5. From the Use reference qualifier choice list, select the reference qualifier to implement.
  6. Configure the qualifier based on the type of reference qualifier.
  7. Complete the Reference Specification — Additional Customization section, as appropriate.
    FieldDescription
    Reference key Identifies a field other than sys_ID to use as the unique identifier for the reference field.
    Reference cascade rule Defines what happens to a record if the record it references is deleted. Possible options include:
    • None
    • Cascade
    • Clear
    • Delete
    • Delete no workflow
    • Restrict
    Reference floats Flag that determines whether to Configure the edit option for one-to-many relationships.
    Dynamic creation Flag that determines if the system should create a new record when a value for the reference field does not match an existing record. If you select this option, enter a script that specifies how to create the record in the Dynamic creation script field.
  8. Click Update.