Finding records
When you perform a find, FileMaker Pro searches through all the records in a table, comparing the search criteria you specify with the data in the table. Records with data matching the criteria become the found set, which is the subset of records being browsed. Records that don’t match are omitted. You can then constrain (narrow) or extend (broaden) the found set.
You can work with just the records in the found set. For example, you can view, edit, calculate summaries for, sort, print, delete, export, or replace data in these records. You can also open another window in order to perform different find requests on the same data. For more information, see Opening multiple windows per file.
To find records, see Making a find request.
To find and replace data, see Finding and replacing data.
Topics in this section
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
Viewing, repeating, or changing the last find
Hiding records from a found set and viewing hidden records
Constraining (narrowing) a found set
Extending (broadening) a found set
Performing quick finds based on data in a field
Finding records troubleshooting
Saving a find request
Managing saved find requests