Anyone Ever Use The FileMaker TableIDs Function?

From Dwayne Wright PMP
Certified FileMaker Developer

TWITTER: dwaynewright
YOUTUBE: FileMakerThoughts

Please Note: If you are viewing this page in a news feeder, the images may get munged up a bit. For the best experience, please visit the journal directly by clicking (here). 

The TableIDs design function was introduced with the release of FileMaker 7, will return a text result and has the syntax of TableIDs ( fileName ). It will return a carriage return list of all the id tags for the table occurrences created within a specified FileMaker file. Please note that this is linked to the table occurrences are the objects found in the relational graph and not just the tables themselves. In the relational graph, a table can (and often is) be represented by multiple table occurrences.

I have to say that I have never seen this function used in the wild and I struggle to think of an occassion in which I would use Table IDs for a particular design goal. Below is a picture of the function in use within the data viewer.

BTW: You may have noticed the embedded function Get(FileName), which will return the name of the current FileMaker file ( sans the extension ) at the moment the function is called upon. So a database with the name of Invoices.FP7 will simply return Invoices. Some other functions will require the name of the file in one of its parameters. In fact, most of the functions in the Design family will require a parameter identifying what file you want the function to look at. In many cases, a developer will use the the Get(FileName)  function here instead of typing in the actual file name. In this case, the Design function will still work correctly if the name of the FileMaker file is changed.

More info about the author and FileMaker in general, contact me at

© 2008 - Dwayne Wright -

The material on this document is offered AS IS. There is NO REPRESENTATION OR WARRANTY, expressed or implied, nor does any other contributor to this document. WARRANTIES OF MERCHANT ABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE EXPRESSLY DISCLAIMED. Consequential and incidental damages are expressly excluded. FileMaker Pro is the registered trademark of FileMaker Inc.