ENFORM User's Guide

Connecting Record Descriptions to Form New Relationships
Developing an ENFORM Query
3–22 058058 Tandem Computers Incorporated
A sketch of the links in the preceding query appears as:
newpart component
npart-1
The report produced is as follows:
PART MAIN COMPONENTS
-------------------- --------------------
16 INCH WORK CENTER PORTABLE WORK TABLE
VISE
3 AMP UNIVER MOTOR
BAND SAW 3 AMP UNIVER MOTOR
BAND SAW BLADE
ROUTER AND SHAPER GD
BAND SAW BLADE
BRACES
CASTERS
MITRE GAUGE
PORTABLE WORK BENCH BRACES
CASTERS
PORTABLE WORK TABLE
... ...
If you are familiar with the data stored in your data base, you can request a report that
lists both the main components of a part and its secondary components (the
components of the main components). In fact, this detailing can continue until the
report breaks each part down to its most elementary component. The preceding query
could be modified to produce such a report as follows:
1. Open the original record descriptions. Use the OPEN AS COPY OF statement to
make two copies of newpart and a single copy of component. (The first copy of
newpart, npart-1, will supply the name of the main components. The second copy
of newpart, npart-2, will supply the name of the secondary components. The copy
of component, cp-1, will supply the secondary components).
OPEN newpart,component;
OPEN cp-1 AS COPY OF component;
OPEN npart-1 AS COPY OF newpart;
OPEN npart-2 AS COPY OF newpart;