Table relationships are defined using the TableRelation Property. This property allows you to define both simple and advanced table relationships. A typical simple table relationship consists of a table name and an optional field name. An advanced table relationship might additionally contain conditions and filters.
To create a table relationship
-
Open Object Designer and click Table to see a list of the tables.
-
Select a table and then click Design.
The table opens in Table Designer.
-
Select the field for which you want to create a relationship and view the Properties window.
-
Set the TableRelation property value by using the following steps:
-
In the TableRelation property value, click the AssistEdit button.
The Table Relation window opens.
-
Click the AssistEdit in the Table cell, select a table, and then click OK.
-
Click the AssistEdit in the Field cell, select a field, and then click OK.
-
Set the Condition or Filter fields, as needed.
-
Click OK.
-