User manual
Table Of Contents
- Preface Introducing FileMaker Pro
- Chapter 1 Using databases
- About database fields and records
- Opening files
- Opening multiple windows per file
- Closing windows and files
- Saving files
- About modes
- Viewing records
- Adding and duplicating records
- Deleting records
- Entering data
- Finding records
- Making a find request
- Finding text and characters
- Finding numbers, dates, times, and timestamps
- Finding ranges of information
- Finding data in related fields
- Finding empty or non-empty fields
- Finding duplicate values
- Finding records that match multiple criteria
- Finding records except those matching criteria
- Deleting and reverting requests
- Viewing, repeating, or changing the last find
- Hiding records from a found set and viewing hidden records
- Finding and replacing data
- Sorting records
- Previewing and printing databases
- Automating tasks with scripts
- Backing up database files
- Setting preferences
- Chapter 2 Creating databases
- Chapter 3 Working with related tables and files
- Chapter 4 Sharing and exchanging data
- Chapter 5 Protecting databases with accounts and privilege sets
- Chapter 6 Converting FileMaker databases from previous versions
- Index
Using databases 19
Selecting the active record
In Browse mode, a table has one active (selected) record at a time for
each window. For more information about working with multiple
windows, see
“Opening multiple windows per file” on page 15.
To select a related record in a portal, select the portal row (click
inside the row but outside any fields in the row). For information
about related records and portals, see
chapter 3, “Working with
related tables and files.”
Moving through records
To move from one record to another, use the book icon in the status
area.
In this view The active record is
View as Form The record that you’re displaying.
View as List
or
View as Table
The record that’s marked with a solid bar along the
left side. To work with another record, click in the
record to make it active.
Current
record in
View as List
To move Do this
To the next record in
the current table
Click the right page of the book icon.
To the previous record
in the current table
Click the left page of the book icon.
Quickly to a specific
record
1 Click the current record number, type the record
number you want, then press Enter (Windows) or
Return (Mac OS).
1 Press Esc, type the record number, then press Enter
or Return.
Click inside the portal row
to select a related record
Portal
Slider
Current record number
Number of records
in the database
Book icon