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
- New features in FileMaker Pro 5.5
- Windows 2000 Professional
- Ease-of-use improvements
- Record-by-record access privileges
- Scripting improvements
- New logical, design, and status functions
- Extended ODBC and SQL functionality
- Import named ranges of Microsoft Excel data
- Search only the relative path for FileMaker Pro files
- Relaxed rules for mapping fields and relationships when importing scripts
- Dynamic field name matching in data import scripts
- Import more graphics file formats
- Increased productivity with FileMaker Server
- Prevent users from changing passwords
- Prevent users from creating databases
- Validation of the number of characters in a field
- Open a FileMaker Pro database via a URL (Mac OS)
- Web publishing enhancements
- Backward compatibility
- New features in FileMaker Pro 5
- Hands-on, task-oriented tutorial
- New features in FileMaker Pro 5.5
- 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 the Custom setup instructions in
“Installing FileMaker Pro” on page 7. For Mac OS systems, see
“Custom installation” on page 22.
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