Creating a relationship between a database table and a user class

  1. Determine the primary table name for the form:
    1. Open the form to which you want to add a UET field.
    2. Select Edit > Design Mode.
    3. If the form properties sheet is not open, select View > Form Properties.
    4. Select the Collections tab on the property sheet.
    5. In the collections tree, select the primary collection.
    6. The Base Table and Alias property shows the primary table name.
    Note: System administrators can use the Metadata Access Controls form to restrict access to application metadata and prevent users from altering core SQL tables. You cannot modify SQL tables that are set to Locked in the Metadata Access Controls form. You can view or select tables that are set to Read Only but you cannot modify them. You can select and modify SQL tables that are set to Unlocked.
  2. Associate a user class with the application database table:
    1. On the UET Table/Class Relationships form, select Actions > New.
    2. In the Table Name field, select the table, as determined above, with which you want to associate a class.
      Note: Only SQL tables that are set to Unlocked in the Metadata Access Controls form display in this list. You can select SQL tables that are set to Read Only but you cannot modify them.
    3. In the Class Name field, select a class to associate with the table.
    4. Select Active to draw user fields on application forms.
    5. Click Rule Assistant.
    6. Select a field, an operator and a value for the rule.
    7. Select OR instead of AND with previous clause if you want to find all records that match one of the search criteria instead of finding all records that match the search criteria in the previous clause.
    8. Click Add to add the rule. The rule displays in the (Criteria) field.
    9. Click OK.
  3. Save your changes.
Related topics