User manual
Table Of Contents
- Chapter 1 Introducing FileMaker Pro
- Chapter 2 Using databases
- About database fields and records
- Opening files
- Opening multiple windows per file
- Closing windows and files
- Saving files
- About modes
- Viewing records
- Adding and duplicating records
- Deleting records
- Entering data
- Finding records
- Making a find request
- Performing quick finds based on data in one field
- Finding text and characters
- Finding numbers, dates, times, and timestamps
- Finding ranges of information
- Finding data in related fields
- Finding empty or non-empty fields
- Finding duplicate values
- Finding records that match multiple criteria
- Finding records except those matching criteria
- Saving find requests
- Deleting and reverting requests
- Viewing, repeating, or changing the last find
- Hiding records from a found set and viewing hidden records
- Finding and replacing data
- Sorting records
- Previewing and printing databases
- Automating tasks with scripts
- Backing up database files
- Setting preferences
- Chapter 3 Creating databases
- Planning a database
- Creating a FileMaker Pro file
- Defining database fields
- Using supplemental fields
- Setting options for fields
- Defining database tables
- Creating layouts and reports
- Setting up a layout to print records in columns
- Working with objects on a layout
- Working with fields on a layout
- Working with parts on a layout
- Chapter 4 Working with related tables and files
- Chapter 5 Sharing and exchanging data
- Sharing databases on a network
- Importing and exporting data
- Saving and sending data in other formats
- Sending email messages based on record data
- Supported import/export file formats
- ODBC and JDBC
- Methods of importing data into an existing file
- About adding records
- About updating existing records
- About updating matching records
- About the importing process
- Converting a data file to a new FileMaker Pro file
- About the exporting process
- Working with external data sources
- Publishing databases on the web
- Chapter 6 Protecting databases with accounts and privilege sets
- Chapter 7 Converting databases from FileMaker Pro 6 and earlier
- Chapter 8 Security measures
- Index
Defining database fields | 81
About naming fields
Follow these guidelines when naming fields:
1 Field names must be unique. They can contain up to 100 characters.
1 Use descriptive names that clearly identify the contents of the field. Avoid
abbreviations, acronyms, or other terms that may cause confusion.
1 Don’t use any of the following symbols or words in the field name:
1 , (comma) + – * / ^ & = ≠ > < ≥ ≤ ( ) [ ] } " ; (semicolon) : (colon) ::
(relational indicator) $ (variable indicator)
1 AND, OR, XOR, NOT, or the name of any FileMaker Pro function
1 Don’t begin a field name to be used in a calculation formula with a space,
period (.), or number.
1 Use _ (underscore) in place of a space to avoid restrictions in ODBC (Open
Database Connectivity) or JDBC (Java Database Connectivity), exporting,
web publishing, and other operations.
1 If you’re exchanging data with another application, check the field naming
restrictions in the file formats supported by the other application.
1 If you’re using ODBC or JDBC to share FileMaker Pro data, avoid using
SQL keywords in field names.
φμπ10_υσερσ_γυιδε.βοοκ Παγε 81 Μονδαψ, Αυγυστ 25, 2008 3:59 ΠΜ