Creating a Table Relationship
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.
Open Object Designer and choose Table to see a list of the tables.
Select a table and then choose 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, choose the AssistEdit button.
The Table Relation window opens.
Choose the AssistEdit in the Table cell, select a table, and then choose OK.
Choose the AssistEdit in the Field cell, select a field, and then choose OK.
Set the Condition or Filter fields, as needed.
Choose OK.