layoutName - the name of a
layout or
table in the specified database file.
If layoutName isn’t specified, then the field names of the first table created (the “default table”) will be returned.
Note If FieldNames returns a question mark (?) or the name of only one field, go to the Specify Calculation dialog box and make sure
Calculation result is text. Also, you can increase the size of the field on the layout to show more field names.
FieldNames(“Customers”;””) returns a list of all the fields in the default table of the Customers database file.
FieldNames(“Customers”;“Data Entry”) returns a list of all the fields, including related fields, in the Customers database file that appear on the Data Entry layout.