RELATION( )

Topic group Related topics

Returns the link expression defined with the SET RELATION command.

Syntax

RELATION(<expN> [,<alias>])

<expN>

The number of a relation that you want to return.

<alias>

The work area you want to check.

Description

RELATION( ) returns a string containing the expression that links one table with another that was defined with the SET RELATION command. You must specify the number of the relation; if the table in the current or specified work area is linked to only one table, that <expN> is the number 1. RELATION( ) returns an empty string ("") if no relation is set in the <expN> position.

Use RELATION( ) to save the link expressions of all SET RELATION settings for later use when restoring relations. To save the target table (the table into which you SET a RELATION), use the TARGET( ) function.

OODML

Check the detail Rowset object’s masterFields and masterRowset properties, or the detail Query object’s masterSource property to determine the nature of the master-detail linkage.