FieldIDs()

FieldIDs()

Category: Design

Syntax: FieldIDs ( fileName ; layoutName )

Parameters: fileName ”the name of the open FileMaker database from which to return IDs; layoutName ”the name of the layout from which to return field IDs.

Description: Returns a list of all field IDs in fileName and layoutName , separated by carriage returns. Fields outside the current table context are returned as TableID::RelatedFieldID . If layoutName is empty, then the field IDs of the first table created (the "default" table) are returned.

Examples:

 FieldIDs ( "Invoices" ; "List View" ) 

returns IDs of all unique fields, including related fields, on the List View layout in Invoices .

Comments:

Calls to FieldIDs() can be broken when file and layout names are changed. Field IDs are assigned by FileMaker and cannot be changed.