Table Relation

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.