One of the toughest challenges in creating a successful database is consistent and accurate data entry. Next to database design, it is the most important step in database development.
Misinformation is worse than no information.
In FileMaker Pro 3.0 Claris has provided new robust tools to aid consistent and accurate data entry. One of the most powerful is the new Validation options in Define Fields. To demonstrate, consider a contact database with a phone number field. Each phone number must include the area code. We will use the Validation options to enforce these data requirements.