From Dwayne Wright PMP
Certified FileMaker Developer
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).
TableNames( fileName )
Introduced With FileMaker 7
Returns A Text Result
The TableNames design function will return a carriage return separated list of all the specified table occurrences in the relational graph in within a specified FileMaker file. This is different that the tables within a FileMaker file because table occurrences are the objects found in the relational graph. In the relational graph, a table can (and often is) be represented by multiple table occurrences.
My blog articles are crafted within a FileMaker database (built without much planning and growing like a weed) has a long list of table occurrences in the relationship graph. Here is an edited copy of some of the names returned when I use the TableNames functions in that database. You may also notice a naming convention that is used in many FileMaker anchor / buoy relationships ecosystems.
Blog Chapter Value List
BTW: Anchor / Buoy
Buoy uses relationships organized into groups and each group doesn’t touch and each group has only one anchor and any number of buoys. Since each group has only one anchor, this means that we are likely to have the same number of groups as we do tables (aka Anchors).
More info about the author and FileMaker in general, contact me at firstname.lastname@example.org.
© 2010 - Dwayne Wright - dwaynewright.com