Help

Finding, sorting, and replacing data
F
ILEMAKER PRO HELP 116
To find data in related fields:
1. Start a find request.
See Making a find request.
2. Enter the find criteria you want.
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, in an Invoice file that is displaying
line items as related records in a portal, you could find all invoices listing a computer by typing
Computer
in the Item field in the portal.
You can also omit related records. See Finding records except those matching criteria.
3. Click Perform Find in the status toolbar, or choose Requests menu > Perform Find.
Related topics
Adding and duplicating related records
Creating portals to display related records
Finding empty or non-empty fields
You can find fields that contain no data or some data.
To find empty or non-empty fields:
1. Start a find request.
See Making a find request.
2. Refer to the following table for examples of different ways to search for empty or non-empty
fields.
3. When you’ve entered the find criteria that you want, click Perform Find in the status toolbar,
or choose Requests menu
> Perform Find.
Note If any value is empty in a repeating field, then a search using “=” returns that field.
To enter data in empty fields:
1. Create a find request that returns the empty field you want to replace.
2. Enter a value in the empty field in one record in the found set.
3. Choose Records menu > Replace Field Contents.
4. Click Replace.
The value you entered is placed in every record in the found set.
Finding duplicate values
You can find all records in which one or more fields contain duplicate values (for example, the same
company name in the Company field in multiple records).
To find fields that are Enter this in the field
Not empty (i.e., fields that have data) *
Empty =