Finding records

Contents > Finding, sorting, and replacing data > Finding records

Finding records

When you perform a find, FileMaker Pro searches through all the records in a table, comparing the 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.

Note If you open a file, perform a find, and then close the file, the found set is not saved. For more information about when a database file is saved, see Saving and copying files.

More detail about 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

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

Contents > Finding, sorting, and replacing data > Finding records