User manual

Chapter 1
|
Using databases 29
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 30.
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.
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 =