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:  Certain tables cannot be extended. See User Extended Tables Overview.
  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.
    3. In the Class Name field, select a class to associate with the table.
    4. Select Active to be able 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