Functions Reference

Chapter 4
|
Design functions 45
Important See Design functions, page 35 for information about literal text parameters.
Data type returned
text
Description
Returns a list of four values for each relationship directly related to tableName. Values
in a list are separated by carriage returns, and lists are separated by two carriage returns.
For each additional relationship connected to tableName, an additional list of four values
is output.
The four values are:
• Source: Data Source Name of the database table connected to tableName
• Table: the name of the table connected to tableName
• Options: the options that were set in the right side of the Edit Relationship dialog
box when the relationship was defined. This line is blank if the following options are
not set; otherwise these options are separated by spaces.
• Delete, if Delete related records in this table when a record is deleted in the
other table is selected in the right side of the Edit Relationship dialog box
• Create, if Allow creation of records in this table via this relationship is
selected in the right side of the Edit Relationship dialog box
• Sorted, if Sort records is selected in the right side of the Edit Relationship dialog
box
• Relationships: a list of the defined relationships, one per line. Field names are
fully qualified, for example, TableName::Field Name.