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