U.M. (Windows)

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.
Current price of the
product—if you
change this value,
FileMaker Pro
doesn’t save the
old price
One record per product
This record describes one
item ordered in Invoice 1
Another 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
Quantity ordered
by the customer