User manual

20 FileMaker Pro User’s Guide
For more information about viewing records, see Help.
Adding and duplicating records
When you add or duplicate records, FileMaker Pro stores new
records at the end of the current table. In Browse mode, you see the
new record after the current record, or after the last record in the
found set (the set of records made active by a find request).
1 If records are sorted, the new record appears immediately after the
current record.
1 If records are unsorted, the new record appears after the last record
in the found set. For more information, see “Sorting records” on
page 30.
Note If a file is locked or write-protected, or if you don’t have access
privileges to create records, FileMaker Pro will not add or duplicate
records.
If the field is defined to automatically enter field values, you see
those values entered in the new record. See
“Defining automatic data
entry” on page 45.
To enter or change values in the new record, see “Entering and
changing data in fields” on page 22.
Adding and duplicating related records
If you’re working with records in related tables, you can add records
to a related table when you enter data in a record in the current table.
Note You can only add related records from the current table if the
relationship is defined to allow the creation of related records. If a
related table is in a write-protected file, or if you don’t have access
privileges to create records, FileMaker Pro will not add or duplicate
records. (See
“Creating relationships” on page 68.)
Quickly through
records
Drag the slider right or left to move forward or
backward.
Through records in
View as List or View as
Table
Use the scroll bar on the right side of the window.
To a record with a
unique value that you
know
See “Finding records” on page 23.
To Do this in Browse mode
Add a new blank record Choose Records menu > New Record. You see a
blank record with one field selected.
Quickly add a record
with the same or similar
data as an existing record
Select the record to duplicate. Then, choose Records
menu > Duplicate Record. (See “Selecting the active
record” on page 19.)
Add or duplicate related
records
See the next section.
To move Do this
To Do this in Browse mode
Add a record to a
related table
1 If the related field is in a portal, type data into the field
in the last (empty) row of the portal, then press Enter.
1 If the related field isn’t in a portal, type data into the
field, then press Enter.
Duplicate a record
that is displaying
related data
Be sure no records in a portal are selected, then choose
Records menu > Duplicate Record.
Duplicate a related
record in a portal
Select the record in the portal, then choose Records
menu > Duplicate Record.