Brian Dunning's FileMaker Custom Functions


Returns list of all unique underlying Base Tables for all Table Occurrences in the current FileMaker Pro v12 file

  Average rating: 4.7 (23 votes) Log in to vote

Andrew Duncan   Andrew Duncan - Show more from this author

Share on Facebook Share on Twitter

  Sample input:
  Sample output:

  Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

Returns list of all unique underlying Base Tables for all Table Occurrences in the current FileMaker Pro v12 file. This requires FileMaker Pro v12 as it uses the new ExecuteSQL function released in FileMaker Pro v12. N.B. it will only return a list of Table names for all Table Occurrences that are on the relationship graph - if you have a Table with no associated Table Occurrences on the graph it will not appear in the result.



Omega Goh   Omega Goh, Singapore
Jul 23, 2013
This is fantastic!

Prior to this, the design function, TableNames returns a list of Table Occurences which I could elimnate only base on my own Naming Convention. For solutions that were not using my own Naming Convention, I have to split the Table Occurence Name to get the list of Field Names to guess the "duplicate". It would tricky if there are two or more Base Tables with the same list of Fields, though not often.

Thank you for your contribution, Andrew.
Morgan   Morgan, Denver
Dec 28, 2017
ExecuteSQL (
"SELECT DISTINCT BaseTableName FROM FileMaker_Tables
WHERE BaseFileName LIKE '" & Get ( FileName ) & "%'"

; "" ; "" )

This pulls up only the distinct base tables of the Table Occurrences in the file. If there is no TO for that table, it doesn't show here.
Andrew   Andrew
Dec 29, 2017
Hi Morgan - unfortunately it does require a Table Occurrence as that is how the FileMaker_Tables function works.

Log in to post comments.


Note: these functions are not guaranteed or supported by Please contact the individual developer with any questions or problems.

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 19 years. It receives no funding and has no advertisements. If it has helped you out, I'd really appreciate it if you could contribute whatever you think it's worth: