Database Reference
In-Depth Information
TIP
If you
don't
turn on the “Specify target field” option, the
Set Field
step modifies
whichever field happens to be active when the step is carried out.
Figure 11-5. This Specify Field dialog box looks almost exactly like the one you've seen in
Layout mode. The only difference is the Repetition box at the bottom. If you select a repeat-
ing field (page 241), then you can use this box to tell FileMaker which repetition to set.
9.
In the field list, select Balance Due and then click OK
.
The Set Field step in your script (
Figure 11-6
) shows the option you've selected. In
the Script Step Options area, click the bottom Specify button (the one beside “Calcu-
lated result”).
FileMaker shows you the Specify Calculation window, the same one you used to
build calculation fields in previous chapters. Here you'll use a calculation to tell
FileMaker what to put in the Invoices::Balance Due field. Remember, you're in Find
mode when this script runs, so the Set Field step tells FileMaker what records you
want to find.
