Reference > Functions reference > Design functions > TableIDs
 

TableIDs

Returns a list of all table occurrence IDs in fileName.

Format 

TableIDs ( fileName )

Parameters 

fileName - the name of an open database file (local or remote).

Data type returned 

text

Originated in 

FileMaker Pro 6.0 or earlier

Description 

Each value is unique and identifies a table occurrence. Also, the ID is independent of when you create each table occurrence: the first table occurrence could have the smallest, middle, or largest value.

Listed items are separated by carriage returns.

Example 1 

TableIDs ( "University Database" ) returns

1065089

1065090

for the University Database database file if two table occurrences have been defined for the file.

Related topics 

Functions reference (category list)

Functions reference (alphabetical list)

About formulas

About functions

Defining calculation fields

Using operators in formulas