Tutorial

Simplifying data entry 41
Automatically enter a serial number
FileMaker Pro lets you automatically enter certain types of data—
for example, incremental numbers—when you create a new record.
Look at a serial number example
1. Choose Window menu > Sample07.
2. Go to the last record in the database.
3. Locate the Member Number field, and note the current number
of this record.
4. Create a new record by choosing Records menu > New Record.
The value in the Member Number field of the new record is
increased by one.
Note If you did the first activity in this chapter, you will notice
that the value in Member Number is 32, even though there are now
31 records in the Sample07.fp7 database. FileMaker Pro continues
to increment serial numbers even if intervening records have been
deleted, such as record 31 in this case.
Create a field for serial numbers
1. Choose Window menu > MyFile07.
2. Choose File menu > Define > Database.
3. In the Define Database dialog box, click the Fields tab if it is
not already selected.
4. For Field Name, type Member Number.
5. Select Number as the field type.
6. Click Create.
7. Click Options.
8. Select Serial number on the Auto-Enter tab. You don’t need to
change the Generate choice, or the amounts for next value or
increment by for this exercise.
9. Click OK, then click OK again to close the dialog box.
The new field appears at the bottom of the layout. (You might
need to scroll down to see it.)
10. Test your new field entry option by choosing Records menu >
New Record. Each time you create a new record, the value in the
Member Number field increments by one.
To learn how to change the position of the new field, see lesson 5.
11. When you are finished with this lesson, close each open file
by choosing File menu > Close.
For more information
You have learned how to simplify data entry by defining and
formatting value lists, calculation fields, and auto-entered serial
numbers. For more information on calculation fields and field
auto-enter options, as well as defining and formatting value lists,
see FileMaker Pro Help.
Select Serial
number