Help

FILEMAKER PRO HELP 1288
• Enter Find Mode
• Perform Find
• Extend Found Set
• Constrain Found Set
For more information on saving a find request, see Saving a find request.
In the Specify Find Requests dialog box:
• New opens the Edit Find Request dialog box, where you define criteria for a find request.
• Edit opens a selected find request from the list.
• Duplicate duplicates one or more selected find requests from the list.
• Delete deletes one or more selected find requests from the list.
In the Edit Find Request dialog box:
1. For Action, select Find Records or Omit Records to specify whether this find request will
find or omit records.
Finding records adds them to your found set. Omitting records excludes them. An individual
request can find or omit records; use multiple requests if you need to find and omit records
during the same Perform Find script step.
2. Find records when (or Omit records when) shows a list of the fields in your current table.
To construct a find request, begin by selecting a field from this list.
• To select a field from a related table, click the name of the current table at the top of the
list and select the related table you want. Select a related field from this new list.
• Change the value in Repetition to specify a particular cell of a repeating field.
3. Type your search criteria for the selected field in the Criteria area.
• Click Insert Operator to further refine your search criteria. See Finding records.
• You can include local variables (beginning with $) and global variables (beginning with
$$) in find requests that you create or edit in the Edit Find Request dialog box. See
“Notes for using variables in find requests,” below.
4. Click Add to add your criteria to the find request.
• To change existing criteria, select the line containing the field and criteria from the top of the
dialog box, and make your changes to the field or criteria. Click Change to store your
changes.
• To delete existing criteria, select the line containing the field and criteria from the top of the
dialog box and click Remove.
5. Click OK.
Notes for using variables in find requests
• A variable in a find request can represent a simple expression (for example, */*/
$birthYear
) or a complex expression (for example, $birthQuery, where the value of
$birthQuery is */*/1994).
• A variable in a find request cannot include the repetition (index) number of a repeating field
(as in the syntax
$variable[repetition]) or a file path.