Quick Start
Table Of Contents
- Chapter 1 Welcome to FileMaker Pro
- Chapter 2 Installing FileMaker Pro in Windows
- Chapter 3 Installing FileMaker Pro in the Mac OS
- Chapter 4 New features in FileMaker Pro
- The user interface’s new look
- New Layout/Report assistant
- Other layout improvements
- ODBC support in FileMakerPro
- Microsoft Excel import and file conversion
- ActiveX Automation support (Windows)
- QuickTime
- Web publishing
- View as Table
- Improvements to value lists
- Import script
- Import Update
- Multi-User (Hidden)
- Hands-on, task-oriented tutorial
- Lesson 1 FileMaker Pro basics
- Lesson 2 Browsing information
- Lesson 3 Finding and sorting records
- Lesson 4 Creating a database and entering records
- Lesson 5 Customizing what you see
- Lesson 6 Creating lists, mailing labels, and form letters
- Lesson 7 Simplifying data entry
- Lesson 8 Automating tasks with buttons and scripts
- Lesson 9 Creating and running reports
- Lesson 10 Making databases relational
- Lesson 11 Keeping your data safe
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
Note You can install a fresh copy of the tutorial files at any time. For
Windows-based systems, see “Compact installation or Custom
installation” on page 9. For Mac OS systems, see “Custom
installation” on page 20.
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 in the FileMaker Pro folder.
2. Open the Sample Files folder.
You should be here: FileMaker Pro\Tutorial\Sample Files.
3. Open Sample07.fp5.
4. Choose Layout #1 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.
Click one to enter the corresponding value in the field.
Define a value list
1. Open the Tutorial folder in the FileMaker Pro folder.
2. Open the Working Files folder.
You should be here: FileMaker Pro\Tutorial\Working Files.
3. Open MyFile07.fp5.
4. Choose Layout #1 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