Reference > Functions reference > Get functions > Get(ActiveFieldTableName)


Returns the name of the table occurrence that contains the field that has the focus.


Get ( ActiveFieldTableName )



Data type returned 


Originated in 

FileMaker Pro 7.0


Returns the table occurrence name for the active field. If there is no active field, this function returns an empty string.

Example 1 

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