Creating a Relationship Between a Database Table and a User Class

Determining the Primary Table Name for a Form

Open the form to which you want to add a UET field.
On the Edit menu, select Design Mode.
If the form properties sheet is not open, select Form Properties on the View menu.
Select the Collections tab on the property sheet.
In the collections tree, select the primary collection.
The Base Table and Alias property shows the primary table name.

NOTE: Certain tables cannot be extended. See the User Extended Tables Overview topic for a list of these tables.

On the UET Table/Class Relationships form, select New from the Actions menu.
In the Table Name field, select the table, as determined above, with which you want to associate a class.
In the Class Name field, select a class to associate with the table.
Select Active to be able to draw user fields on application forms.
Click the Rule Assistant button to access the UET Rule Assistant form.
On the UET Rule Assistant form, select a field from the (Field) field.
In the (Operator) field, select an operator.
In the (Value) field, enter a value for the rule.
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.
Click Add to add the rule. The rule displays in the (Criteria) field.
Click OK. You return to the UET Table/Class Relationships form.
On the Form menu, select Close and Save Changes.