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, or the name of any FileMaker Pro Advanced function
•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 Advanced data, avoid using SQL keywords in field names.