Share via


How to: Create 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.

To create a table relationship

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

  2. Select a table and then choose 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, choose the AssistEdit button.

      The Table Relation window opens.

    2. Choose the AssistEdit in the Table cell, select a table, and then choose OK.

    3. Choose the AssistEdit in the Field cell, select a field, and then choose OK.

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

    5. Choose OK.

See Also

Concepts

Setting Relationships Between Tables