Filemaker Pro 8.5 Educational Maintenance T3 TJ083LL/A User Manual
Product codes
TJ083LL/A
52 FileMaker Functions Reference
Example
A database file called Human Resources has three tables: Company, Employees, and
Addresses. Company::Company ID is connected to Employees::Company ID,
Employees::Employee ID
Addresses. Company::Company ID is connected to Employees::Company ID,
Employees::Employee ID
is connected to Addresses::Employee ID and
Employees::DateOfHire
is connected to Addresses::DateMovedIn.
The relationships have the following criteria:
•
•
You can create records in all tables.
•
You cannot delete records in all tables.
•
A sort was specified for the Addresses table for the Employees<-->Addresses
relationship.
relationship.
RelationInfo(“Human Resources”;“Employees”)
returns:
Source: Human Resources
Table: Company
Options: Create
Company::Company ID = Employees::Company ID
Table: Company
Options: Create
Company::Company ID = Employees::Company ID
Source: Human Resources
Table: Addresses
Options: Create Sorted
Addresses::Employee ID = Employees::Employee ID
Addresses::DateMovedIn >= Employees::DateOfHire
Table: Addresses
Options: Create Sorted
Addresses::Employee ID = Employees::Employee ID
Addresses::DateMovedIn >= Employees::DateOfHire
ScriptIDs
Format
ScriptIDs(fileName)
Parameter
fileName - the name of an open
(local or remote).
Important
See “Design functions” on page 41 for information about literal text parameters.
Data type returned
text
Description
IDs in fileName, separated by carriage returns.