Putting Your Data to Work for You
Buttons can do a lot of tricks for you by finding and sorting records, and moving between files and layouts. Lookups and other auto-enter fields do some of the data entry for you. Now let’s put down those pocket calculators and let FMP calculation fields do that work for you, too. You got your first taste of what can be done with calculation fields in our ILI table back in Chapter 7. We used them to provide line totals in the portal on the invoice, and the InvoiceTotal that gave us a grand total of all the line totals. We also used calculations to make a field that combined a customer’s first and last names as well as company name.
In this chapter, we’ll look at the four categories of ...