Topic group Related topics
Returns the link expression defined with the SET RELATION command.
The number of a relation that you want to return.
The work area you want to check.
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.
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.