Functions Reference

48 FileMaker Functions Reference
TableNames
Format
TableNames(fileName)
Parameter
fileName - the name of an open database file (local or remote).
Important See Design functions, page 35 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, page 35 for information about literal text parameters.
Data type returned
text
Description
Returns a list of all value list IDs in fileName, separated by carriage returns.
Example
ValueListIDs(“Customers”) returns a list of all the value list IDs in the Customers
database file.