U.M. (Windows)

10-42 FileMaker Pro User’s Guide
2. Define the Total field in the Invoices file.
The Total field is an unstored calculation that adds the extended price
of all line items. Use the Line Items relationship to define Total as:
Sum(Line Items::Extended Price)
Example step 5: Create layouts
Create layouts in the master files for data entry and reports. (See
chapter 3, “Laying out and arranging information.”)
Example step 6: Enter data
Enter data in the Products and Customers files, and then test your
database by creating records in the Invoices file. (See “Adding data to a
file” on page 4-3.)
File Layout names Description
Invoices Order Entry Standard layout with a portal.
1 Place these fields from the Customers file
directly in the layout: First Name, Last Name,
Address, City, and State.
1 In the Portal Setup dialog box, choose the Line
Items relationship and Allow deletion of portal
records. Place these fields from the Line Items
file in the first row of the portal: Product ID,
Product Name, Unit Price, Qty, and
Extended Price.
Customers
1 Data Entry
1 Mailing labels
1 Standard layout
1 Labels layout
Line Items
1 Sales Report by Product
1 Sales Report by Month
1 Standard layout with subsummary by product
1 Standard layout with subsummary by month
Products Data Entry Standard layout