Pro-Form Quick Start 9.0 User's Guide download pdf (Page 45)

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 simplify 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 data 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. Value lists are an efficient way to enter

frequently used values into your database.

Define a value list

In this exercise, you will create a value list called Customer Types. In a later step, you will use this

Customer Types value list to assign values to the Customer Type field.

1. Open Sample Copy.fmp12.

2. Choose Data Entry from the Layout pop-up menu in the layout bar, if it is not already selected.

3. Choose File menu > Manage > Value Lists.

4. Click New.

5. Name the new value list by typing Customer Types.

6. Click in the Use custom values text box and type New and Continuing, each on its own line.

A value list with predefined values, displayed as radio buttons

1 2 ... 40 41 42 43 44 45 46 47 48 49 50 ... 81 82

No comments

Pro-Form Quick Start 9.0 User's Guide Page 45