Returns the link expression defined with the SET RELATION command.


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


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.