CR9.2
SQL7 db
1 group on prod id
design:
RH (time and date)
PH suppressed
Da (prod id and specs) and sub1 linked to specs
Db (sub2 linked to specs in (Da) exceptions from sub1
Dc (shared numvar sub1 and sub2) to calc weight formulas
Dd (yellow)
RF suppressed
PF filepath and page 1 of 57
preview:
RH 03/12/04
Da field1 filed2 field3 field4
Da prod1-pack 25.00 75days prod1-content(sub1=content specs)
Db excceptions from sub1 (sub2=content specs)
Dc sub1 and sub2 shared value to claculate weights
Dd (yellow) to distinguish difference prod1 from prod2 etc.
The results I get are 7 different products on page 1
page 2 has product 6 and 7 repeated at top of page
page 2 products 13 and 14 are repeated on page 3
etc.
I have chosen select expert for products 6,7 and 13,14 they are not duplicates
I have 285 records
A new page after returns with 285 pages no duplicates
JUST REPEATS!!
Help!
To all responders: You have got to be commended for answering all of these posts. You all are gods to a newbie like myself.
Thanks again
SQL7 db
1 group on prod id
design:
RH (time and date)
PH suppressed
Da (prod id and specs) and sub1 linked to specs
Db (sub2 linked to specs in (Da) exceptions from sub1
Dc (shared numvar sub1 and sub2) to calc weight formulas
Dd (yellow)
RF suppressed
PF filepath and page 1 of 57
preview:
RH 03/12/04
Da field1 filed2 field3 field4
Da prod1-pack 25.00 75days prod1-content(sub1=content specs)
Db excceptions from sub1 (sub2=content specs)
Dc sub1 and sub2 shared value to claculate weights
Dd (yellow) to distinguish difference prod1 from prod2 etc.
The results I get are 7 different products on page 1
page 2 has product 6 and 7 repeated at top of page
page 2 products 13 and 14 are repeated on page 3
etc.
I have chosen select expert for products 6,7 and 13,14 they are not duplicates
I have 285 records
A new page after returns with 285 pages no duplicates
JUST REPEATS!!
Help!
To all responders: You have got to be commended for answering all of these posts. You all are gods to a newbie like myself.
Thanks again