U.M. (Windows)

Using data from related files 10-41
3. Define these fields in the Line Items file:
4. Define these fields in the Invoices file:
Example step 3: Define relationships
After you define the fields, define the relationships from the master files.
Example step 4: Define fields that use relationships
When the relationships are defined, you can create the lookup
and calculations.
1. Define these fields in the Line Items file:
Field name Field type
Invoice ID Number
Product ID Text
Qty Number
Field name Field type Select this Auto Enter entry option
Customer ID Number
Agent Name Text
Invoice ID Number Serial number
Order Date Date Creation Date
Master file Related file Relationship name Match fields Select these options for the relationship
Line Items Products Products Product ID
Invoices Customers Customers Customer ID
Invoices Line Items Line Items Invoice ID
1 When deleting a record in this file, also delete
related records
1 Allow creation of related records
Field name Field type Comments
Unit Price Number A lookup to Unit Price in the Products file. Use the
Products relationship.
Extended Price Calculation Enter the calculation Unit Price * Qty. Use fields
from the current file (not the Products relationship).
Product Name Calculation Use the related field Products::Product Name. For
Calculation result is, choose Text.