GetTableNamesFromFieldList ( FieldList ; TableList )
Return a unique list of table names parsed by a list of fully qualified field names. Can be used to get the list of all the table occurrences that appear in the current layout.
Be the first to rate this function Log in to vote
Federico Severin - Show more from this author
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
Return a unique list of table names parsed by a list of fully qualified field names.
- FieldList: the list of field names.
- TableList: the list to which each new found table name will be appended. Can be an empty string, or not (see below).
Setting TableList as an empty string (""), the result is the list:
Leaving the TableList parameter empty may seem to be pointless, but is a useful strategy to properly perform a tail recursion.
It may be useful, however, to set TableList to a non-empty value in some cases.
I.e.: when you use the FieldNames ( ) function, it will give back a list of fields where only related fields have a fully qualified name.
So, you can make a call like this:
GetTableNamesFromFieldList ( FieldNames ( Get ( fileName ) ; Get ( layoutName ) ) ; Get ( LayoutTableName ) )
to obtain the list of all the table occurrences that appear in the current layout. By the way, this is the reason why I created this function.
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.