You can set temporary relationships between open tables in so that when the record pointer in one table moves, the record pointer in the other table follows. You can also create a temporary relationship in a single table.

Tip:

Typically, you set a temporary relationship between tables that have a common field using a relational expression. The relational expression is typically the index expression of the controlling index in the child table.

To set a temporary relationship between tables programmatically

Use the SET RELATION command.

You can also use SET RELATION to establish a relationship between a single parent table and various child tables. You can also set a relationship between a table open in the currently selected work area and another table open in another work area by using the SET RELATION command. For more information, see SET RELATION Command.