The FileMaker TableNames Function

From Dwayne Wright PMP
Certified FileMaker Developer

WEB: www.dwaynewright.com
EMAIL: info@dwaynewright.com
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). 

TableNames
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.

Advertisements
AFA_Join
Blog
blog_ADS__active
blog_ADS__current
blog_AFA_BLOGS
blog_AFAJOIN__
blog_BLOG__byBlog
blog_BLOG__selfCurrentDate
blog_Chapter_ValueList
blog_Crosswords
blog_Crosswords__new
blog_IMAGES
blog_MAIL_Tech
blog_QUIZ
blog_RandomThoughtChaptersVL
blog_TERMS
blog_ValueList
Blog Chapter Value List
blogBook
Crosswords
QUIZ
QUIZ_ANSWERLOG
Terms
Test Table

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 info@dwaynewright.com.

© 2010 - Dwayne Wright - dwaynewright.com