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
Important Copy the Tutorial folder to your hard drive or verify that
it is installed before beginning this lesson. See
“Where to find the
lesson files” on page 7 for more information.
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.
Look at the sample value list
1. Open the Tutorial folder on your hard drive.
2. Open the Sample Files folder.
3. Open Sample07.fp7.
4. Choose Data Entry from the Layout pop-up menu if it is not
already selected.
5. Locate the Membership Type field on the current record.
You see two radio buttons, one for New and one for Continuing.
These correspond to the two choices in the Membership Types
value list.
6. Click one to enter the corresponding value in the field.
Define a value list
1. Open the Tutorial folder on your hard drive.
2. Open the Working Files folder.
3. Open MyFile07.fp7.
4. Choose Data Entry from the Layout pop-up menu if it is not
already selected.
5. Choose File menu > Define > Value Lists.
6. Click New.
7. Name the new value list by typing Membership Types.
A value list with predefined values, displayed as radio buttons