RelationInfo()

Category: Design

Syntax: RelationInfo ( fileName; tableOccurrence )

Parameters:

fileNameA string or text expression representing the name of an open file.

tableOccurrenceA string or text expression representing the name of a particular table occurrence in fileName.

Data type returned: Text

Description:

Returns a list of information about all the table occurrences that are related to the specified tableOccurrence.

The results are formatted as

 FileName
 Related Table Reference::Related Field
 Local Related Field
 Options for "right" side of relationship ("Delete", "Create" and/or "Sorted")

Repeat above four lines for each relationship.

The RelationInfo() function returns four lines for each table occurrence thats related to the one you specify. If there are no options selected on the "right" side of the relationship, the fourth line is blank.

Examples:

RelationInfo (Get(FileName);"Contacts 2") might return values that look like this:

MyDatabase
Invoice_Line::ContactID_fk
ContactID_pk
Delete Sorted
MyDatabase
Phone_Nums::ContactID_fk
ContactID_pk
Delete