home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Shareware 1 2 the Maxx
/
sw_1.zip
/
sw_1
/
TEXT
/
PDX_ALL.ZIP
/
TI500.ASC
< prev
next >
Wrap
Text File
|
1991-09-11
|
3KB
|
133 lines
PRODUCT : PARADOX NUMBER : 500
VERSION : 3.xx
OS : PC DOS
DATE : September 11, 1991 PAGE : 1/2
TITLE : CREATING A REPORT WITH A ONE-TO-MANY RELATIONSHIP
NOTE: THE INFORMATION ON THIS SHEET ASSUMES THE USER HAS A
THOROUGH UNDERSTANDING OF PARADOX QUERY AND REPORT
GENERATION.
In this example, the following tables will be used:
┌───────────────────┐ ┌───────────────────┐ ┌───────────────────┐
│ "CUSTOMER" │ │ "ORDERS" │ │ "QUOTES" │
│ ────────── │ │ ──────── │ │ ──────── │
│ Cust# N* │ │ Cust# N* │ │ Cust# N* │
│ Name A35 │ │ Order# N* │ │ Quote# N* │
│ Address A35 │ │ Item A20 │ │ Item A20 │
│ City A25 │ │ Price $ │ │ Price $ │
│ State A2 │ │ Quantity N │ │ Quantity N │
│ Zip A10 │ │ │ │ Status A1 │
└───────────────────┘ └───────────────────┘ └───────────────────┘
Using the above tables, we assume that each customer may have
many orders and many quotations. By manipulating these tables,
we will be able to generate a report listing the customers with
their quotations and orders grouped together. Follow these
steps:
1. <C>reate a new table called "CUSTRPT". Borrow the structure
from "ORDERS" and "QUOTES". Key the first "Cust#" field and
delete the extra "Cust#" field on row 6. You will also need
to delete one of the "Item", "Price", and "Quantity" fields
from the structure. Then, select <D>oIt!
2. <A>sk the "CUSTRPT" table, type INSERT in the leftmost
column. Then, below each field with a corresponding field
in the "ORDERS" table, type in a unique example element
using the <F5> key.
3. Move down to the second row of "CUSTRPT" query by pressing
the down-arrow key. Then, type INSERT in the leftmost
column again. Below each field with a corresponding field
to the "QUOTES" table, type in a unique example element
using the <F5> key.
4. <A>sk the "ORDERS" table. Then, in each field, type the
example element from the corresponding field from the first
row of the "CUSTRPT" query.
PRODUCT : PARADOX NUMBER : 500
VERSION : 3.xx
OS : PC DOS
DATE : September 11, 1991 PAGE : 2/2
TITLE : CREATING A REPORT WITH A ONE-TO-MANY RELATIONSHIP
5. <A>sk the "QUOTES" table. Then, in each field, type the
example element from the corresponding field from the second
row of the "CUSTRPT" query.
6. Press the <F2> key.
7. Now, create a Free-form report on the "CUSTRPT" table. In
the report, place a group on "Cust#". Then, do a lookup to
the "CUSTOMER" table linking by the "Cust#" field. Place
all the fields from the "CUSTOMER" table in the "Cust#"
group header. Then, place all the "CUSTRPT" detail fields
in the form band. Turn on line squeeze by selecting
<S>ettings <R>emoveblanks <L>inesqueeze.
8. You are now ready to output your report.