Reference > Functions reference > Get functions > Get(ActiveFieldTableName)
 
Get(ActiveFieldTableName)
Purpose 
Returns the name of the table that contains the field that has the focus.
Format 
Get(ActiveFieldTableName)
Parameters 
None
Data type returned 
text
Originated in 
FileMaker Pro 7.0
Description 
Returns the table occurrence name for the active field. If there is no active field, this function returns an empty string.
Examples 
There are two fields, Teachers::Name and Coaches::Name, on the current layout based on the Classes table occurrence. The Classes table occurrence is related to the Teachers table occurrence and the CoachesA table occurrence (whose source table is Coaches). Creating a script that returns the result of Get(ActiveFieldTableName) to a third field will return Teachers when the script is performed after clicking in the Teachers::Name field, or will return CoachesA after clicking in the Coaches::Name field.
Related topics 
Functions reference (category list)
Functions reference (alphabetical list)
About formulas
About functions
Defining calculation fields
Using operators in formulas