U.M. (Mac OS)

10-38 FileMaker Pro User’s Guide
1 A Line Items file stores the order number, product identification
number, price, and quantity of each item in every invoice. For every
line item in the Invoice, there’s one record in the Line Items file.
1 An Invoices file is used for order entry and billing. When a customer
places an order, an agent enters a customer identification number to
display the customer’s name and address. The agent enters data in the
Product ID field for each item ordered. FileMaker Pro enters data in
the Invoice Number and the Order Date fields.
One record per product
Current price
of the
product—if
you change
this value,
FileMaker Pro
doesn’t save
the old price
This record describes one
item ordered in Invoice 1
Price when the
customer
places the
order— the
price might be
different from
the current
price in the
Products file
Another item ordered
in Invoice 1
Quantity
ordered by
the customer