Creating a relationship between a database table and a user class

Determine the name of the primary table for the form:
1. Open the form to which you want to add a user-extended table (UET) field.
2. Launch the designer (Web Designer in the web client, Design Mode in the Windows client).
3. If the Form Properties sheet is not displaying, select the Form tab.
4. Select the Collections tab on the property sheet.
  
  Note: In the Web Designer, this tab is located on the Details panel.
5. In the Collections tree, select the primary collection.
6. Take note of the primary table name, as displayed in the Base Table and Alias property field.
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.
Associate a user class with the application database table:
1. Open the UET Table/Class Relationships form, and execute Filter-In-Place.
2. Initiate a new record.
3. In the Table Name field, select the table you noted in the previous step.
  
  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.
4. In the Class Name field, select a user class to associate with the table.
5. To enable you to draw the user-defined fields on forms, select Active.
6. Click Rule Assistant.
7. Select a field, an operator and a value for the rule.
8. 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, select OR instead of AND with previous clause.
9. Click Add.
  The rule displays in the (Criteria) field.
10. Click OK.
Save your changes.