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 the Tutorial folder on your hard drive.
2. Open Sample Copy.fp7.
3. Choose Data Entry from the Layout pop-up menu if it is not already
selected.
4. Choose File menu > Manage > Value Lists.
5. Click New.
6. Name the new value list by typing Membership Types.
7. Click in the large box and enter the values for this list, New and
Continuing, by typing each value on its own line.
8. Click OK to close the Edit Value List dialog box.
9. Click OK to finish.
Assign a value list to a field and display it as radio buttons
1. Choose View menu > Layout Mode.
2. Select the Membership info tab, if it is not already displayed.
3. Select the Membership Type field.
4. Choose Format menu > Field/Control > Setup.
5. For Display as, choose Radio Button Set.
A value list with predefined values, displayed as radio buttons