Tutorial

Lesson 7
Simplifying data entry
You can simplify the way you enter data in FileMaker Pro and improve accuracy by using value lists,
calculation fields, and data auto-entry.
In this lesson, you will:
1 see how value lists can aid data entry
1 write and test a calculation formula
1 use a field’s auto-entry options to automatically enter data
Enter data using value lists
Value lists let you choose the value you want from a scrolling list, a pop-up menu, checkboxes, or radio
buttons. These lists can contain predefined values, or can be constructed dynamically based on the values in
a particular field. They are an efficient way to enter frequently used values into your database.
Define a value list
1. Open Sample Copy.fp7.
2. Choose Data Entry from the Layout pop-up menu, if it is not already selected.
3. Choose File menu > Manage > Value Lists.
4. Click New.
5. Name the new value list by typing Membership Types.
6. Click in the Use custom values text box and enter the values for this list, New and Continuing, typing
each value on its own line.
A value list with predefined values, displayed as radio buttons