Finding data in related fields
You can enter find criteria in related fields that are displayed in a portal or directly on a layout.
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
Was this topic helpful? Send feedback.