Filemaker Pro 8.5 Educational Maintenance T1 TJ086LL/A User Manual

Product codes
TJ086LL/A
Page of 238
Chapter 4
  
|
  Design functions     51
Example
LayoutObjectNames ("Customers";"Data Entry")
 returns a list of named 
objects in the Customers database file that appear on the Data Entry layout.
RelationInfo
Format
RelationInfo(fileName;tableName)
Parameters
fileName
 - the name of an open 
 (local or remote).
tableName
 - the name of a 
 in the specified database file.
Important  
See FileMaker Pro Help for information about literal text parameters.
Data type returned
text
Description
Returns a list of four values for each 
 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:
 the name of the database file that holds 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.