Database Reference
In-Depth Information
2. Select the second and third steps in your script ( Enter Find Mode and Set Field
) .
You can select both by clicking Enter Find Mode in your script and then Shift-click-
ing Set Field .
NOTE
Select the steps in your script (on the right-hand side of the window), not the steps in the
available script steps list (on the window's left side).
3. Click Clear .
FileMaker removes the two selected steps from the script. It now has two steps that
look a lot like the simplified process in Figure 11-9 . Also notice that the Perform
Find step is already highlighted, since FileMaker automatically selects the next step
when you clear one or more steps from the script.
4. In the Script Step Options area, turn on the “Specify find requests” checkbox .
The Specify Find Requests dialog box ( Figure 11-7 ) appears, and, like the Sort script
step in the previous tutorial, it's already set with the find you did when you planned
your script. Since that's exactly what you want, you don't need to do anything in the
Specify Find Requests dialog box. But if you skipped the recommended planning
work on Preparing the Database , then you have to set your find request manually now,
as described in steps 5−7.
5. Click New .
The Edit Find Request dialog box appears. See Figure 11-8 .
6. In the “Find records when” pop-up menu, choose Invoices, if necessary and then
scroll through the list until you see the Balance Due field. Click to select it .
The Balance Due field is highlighted so you can remember which field you're telling
FileMaker to search.
Search WWH ::




Custom Search