Introduction to ENFORM

Building the Target File
How ENFORM Works
3–6 058051 Tandem Computers Incorporated
Figure 3-2. Building the Target File
suppnum
partnum
inventory
price
price * inventory
AVG SUM
SUM OVER ALL
1. Fields Selected from Files, Derived Fields Calculated
partnum partname inventory location
. . . .
suppnum
. . . .
price
suppnum
partnum
inventory
price
price * inventory
Linked Record Description
Derived Field
suppnum
Changes
2. Calculations Over Groups of Records
suppnum
partnum
inventory
price
price * inventory
AVG
suppnum
partnum
inventory
price
price * inventory
SUM
suppnum
partnum
inventory
price
price * inventory
SUM OVER ALL
3. Completed Target File