Constrain Found Set

Narrows the existing found set using the current or stored find requests.


Specify find requests allows you to create and store a find request with the script step. Restore indicates a stored find request.


Product Supported
FileMaker Pro Yes
FileMaker Go Yes
FileMaker WebDirect Yes
FileMaker Server Yes
FileMaker Cloud Yes
FileMaker Data API Yes
Custom Web Publishing Yes

Originated in version 

6.0 or earlier


This script step is equivalent to a logical AND search. Otherwise, Constrain Found Set is similar to the Perform Find script step.


  • If no records match the find criteria, this script step returns a found set of zero records.

Example 1 

Constrains the found set to paid invoices or shows all records.

Show Custom Dialog ["Display only paid invoices?"]
If [Get ( LastMessageChoice ) = 1]
    Enter Find Mode [Pause: Off]
    Set Field [Invoices::Status; "Paid"]
    Constrain Found Set [ ]
    Show All Records
End If