Functions Reference

54 FileMaker Functions Reference
Example
TableIDs(“University Database”) returns
1065089
1065090
for the University Database database file if two tables have been defined for the file.
TableNames
Format
TableNames(fileName)
Parameter
fileName - the name of an open database file (local or remote).
Important See “Design functions” on page 41 for information about literal text parameters.
Data type returned
text
Description
Returns a list of all table occurrences in the relationships graph for fileName, separated
by carriage returns.
Example
TableNames(“University Database”) returns table occurrences
Teachers
Coaches
for the University Database database file if a Teachers table and a Coaches table have
been defined for the file.
ValueListIDs
Format
ValueListIDs(fileName)
Parameter
fileName - the name of an open database file
(local or remote).
Important See “Design functions” on page 41 for information about literal text parameters.