About naming fields

Field names must be unique within a table. Follow these guidelines when naming fields:

  • Do not use any of the following symbols and words in the field name:

    • ,(comma), +, -, *, /, \, ^, &, =, ≠, >, <, ( ), [ ], { }, ", ; (semicolon), : (colon), :: (relational indicator), $ (variable indicator)

    • AND, OR, NOT, XOR, TRUE, FALSE, the name of any FileMaker Pro function, named constant or other special keyword

  • Don't begin a field name to be used in a calculation formula with a space, period (.), or number.

  • Use _ (underscore) in place of a space to avoid restrictions in ODBC, exporting, web publishing, and other operations.

  • If you're exchanging data with another application, check the field naming restrictions in the file formats supported by that application.

  • If you're using ODBC or JDBC to share FileMaker Pro data, avoid using SQL keywords in field names.

Related topics