Sets up a lookup into another table.
When you create table relations, you can define a simple or an advanced table relationship. A typical simple table relationship consists of a table name and an optional field name. An advanced table relationship can also contain conditions and filters.
To open this window, open Table Designer, and then select a field. On the View menu, choose Properties, locate the Table Relation property, and then in the Value field, choose the AssistEdit button.
Fields
| Field | Description |
|---|---|
Condition | The table relations condition to use for the lookup. |
Table | The table to set up the lookup for. |
Field | A field in the related table. |
Table Filter | A constant expression or a filter expression. |