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

  1. Open Object Designer and click Table to see a list of the tables.

  2. Select a table and then click Design.

    The table opens in Table Designer.

  3. Select the field for which you want to create a relationship and view the Properties window.

  4. Set the TableRelation property value by using the following steps:

    1. In the TableRelation property value, click the AssistEdit button.

      The Table Relation window opens.

    2. Click the AssistEdit in the Table cell, select a table, and then click OK.

    3. Click the AssistEdit in the Field cell, select a field, and then click OK.

    4. Set the Condition or Filter fields, as needed.

    5. Click OK.

See Also