GetBaseTableName

Returns the base table name of a field reference.

Format 

GetBaseTableName ( field )

Parameters 

field - any field object or evaluation of a text expression that refers to a field's name

Data type returned 

text

Originated in version 

20.1

Description 

Use this function to get the name of the base table for a field on a table occurrence.

Example 1 

GetBaseTableName(x) returns the name of a table reference passed into a custom function as parameter x.

GetBaseTableName(Evaluate(<fieldName>)) returns the name of a table based on the data stored in <fieldName>.

GetBaseTableName(Evaluate(Get(ActiveFieldName))) returns the table name for a field that has the focus when executed.