Linking table

[maha12]

Hi

I am using CR 8.5 and Access 2000

My tables are
PRHead
ID PRNo Company ... ...
1 111 ABC
PRBody
ID Description PRQty PONo POQty (PONo and POQty
1 Desc1 40 100 40 are filled when
1 Desc2 45 100 45 raising the PO)

POHead
ID PONo ... ...
4 100
POBody
ID PRNo Description POQty GRNNo GRNQty
4 111 Desc1 40 222 40
4 111 Desc2 45 222 45

My report fields are
Description,PRQty,PoNo,PoQty from PRBody and GRNNo,GRNQty from POBody.

Using Visual linking Expert I have linked these tables PRHead.PRNo=POBody.PRNo

Report output is
Description PRQty PONo POQty GRNNo GRNQty
Desc1 40 100 40 222 40
Desc2 45 100 45 222 45
Desc1 40 100 40 222 40
Desc2 45 100 45 222 45

Expect Report output should be
Description PRQty PONo POQty GRNNo GRNQty
Desc1 40 100 40 222 40
Desc2 45 100 45 222 45

How to avoid this doubling records

Tks
Maha

 

[MisterMo]

Menu>Database>Select distinct if is available in CR8.5
else
create a group by Description and place all your fields in the group header or footer and then suppress the detail section.
else
if you can create a command in CR8 you can write the sql statement in there using a select ditinct on your query.

Mo

 

[Naith]

Your linking strategy may be incorrect, where you are missing a link to one of the foreign keys in POBody. Check with your DBA what the appropriate links between these two tables should be.

Naith