ListBaseTableName ( TableOccurrenceName )

Returns the base table name based on the table occurance on a layout in the current FileMaker Pro v12 file

Average rating: 4.6 (27 votes) Log in to vote

Lazarus Sismanis - Show more from this author
Decision Group
http://www.decisiongroup.net

Sample input:

ListBaseTableName(customers_local)

Sample output:

customers

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

/*
*	SYNTAX:   ListBaseTableName
*	ORIGIN:   http://www.decisiongroup.net
* 	NOTES:    Returns the base table name based on the table occurance on in the current FileMaker Pro v12 file
*	VERSION:   1.0v2 - for FileMaker Pro v12
*	Created: 2012 Lazarus Sismanis, Decision Group Inc., Blue Bell, PA, USA
*	Modified: 2021-06-14 - Modified to account for empty value for TableOccurenceName - when empty uses value for current layout.
*	Requires FileMaker Pro v12 or higher
*	Thanks to  Andrew Duncan, Databuzz, Sydney, Australia for his ListBaseTables function
*/

Let (

	~to = If ( IsEmpty (  TableOccurrenceName ) ; Get ( LayoutTableName ) ; TableOccurrenceName ) ;

	ExecuteSQL (	"SELECT DISTINCT BaseTableName 
			FROM FileMaker_Tables 
			WHERE TableName='" & ~to & "'" ; 
			"" ; 
			"" 
		 )

)

When you need to get the base table name for a particular layout table occurrence. i.e. the table occurrence of 'customers_local' uses the base table of 'customers' from the particular file or another data source.

ListBaseTableName(Get ( LayoutTableName )) lists the base table name for the table occurrence on the current layout

Comments

		tawfiq, Jeddah Apr 29, 2015
Thank you, very useful in large files.

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

ListBaseTableName ( TableOccurrenceName )

Comments

Support this website.

Support this website.