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.
The table relations condition to use for the lookup.
The table to set up the lookup for.
A field in the related table.
A constant expression or a filter expression.