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. |