Database Reference
In-Depth Information
Figure 9-6. FileMaker gives you a handy syntax reference for each function you choose
from the function list. When you double-click to place the function in the calculation box,
FileMaker even highlights the parameters for you, so you can start building right away. If
you aren't sure what to do, click the “Learn More” link at the bottom left of the dialog box
for context-sensitive help.
8. Click OK in each dialog box to return to your layout .
If you've done everything right, the Specify Calculation window disappears. If not,
check the syntax of your calculation and then try again.
Your Invoice::Total Due field should now work perfectly. Since you modified an existing
field that's already on your layout, you don't need to do anything else. Every layout that
shows the Invoice::Total Due field now shows the new calculated value.
Switch to the Invoices layout to try for yourself. As you edit, add, or delete Line Item re-
cords, the Invoices::Total Due field changes automatically to reflect the correct total.
Search WWH ::




Custom Search