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 27
Finding data in related fields
You can enter find criteria in related fields that are displayed in a
portal or directly on a layout.
When you perform a find in a related field, FileMaker Pro displays
all the records that have a related record matching the criteria you
enter. For example, suppose you have an invoice file that displays
line items as related records in a portal. To find all invoices listing a
computer, type
Computer in the Item field in the portal. For
information about related fields, see
chapter 3, “Working with
related tables and files.”
For information about omitting related records, see “Finding records
except those matching criteria” on page 28.
Finding empty or non-empty fields
Finding duplicate values
You can find all records for which one or more fields contain
duplicate
values. For example, you might want to find all records that
aren’t unique, then examine them to decide which records to use or
delete.
To find all duplicate records, choose View menu > Find Mode and type
! in the field.
Finding records that match multiple criteria
You can narrow or broaden your search by using more than one
criterion.
Records matching all criteria specified (logical AND search)
To narrow your search, enter criteria in as many fields as needed to
make your request specific, then click
Find.
You can narrow find results incrementally, looking for more specific
detail as you search your database. See the next section.
Constraining (narrowing) a found set
For example, after searching for all of the employees who work in
Sales, you can narrow the search to find all of the employees in Sales
named Alvarez:
1. In Find mode, perform a find to find all of the employees who
work in Sales.
FileMaker Pro displays the found set in Browse mode.
2. Switch back to Find mode and type the criteria to narrow the
search (type Alvarez in the Last Name field).
3. Choose Requests menu > Constrain Found Set.
The found set now consists of employees in Sales named Alvarez.
E154Invoice ID
AlvarezName
Item ID Item
I100 Computer
I202 Desk
I153 Lamp
I229 Bookcase
I448 Chair
Find request
E153Invoice ID
TangName
Item ID Item
I202 Desk
I443 Long table
I153 Lamp
I288 Round table
I100 Computer
Invoice ID
Name
Item ID Item
Computer
E152Invoice ID
DurandName
Item ID Item
I384 Swivel chair
I554 Panels
I288 Round table
I100 Computer
I448 Chair
Records in table
To find fields that are Type this in the field
Not empty (i.e., fields that have data) *
Empty =