Can't figure this table linking problem

[dean12]

I've got a table linking problem I don't know how to handle. Three tables are involved:

OrderHeader
-----------
OrderNumber
SupplierNumber


OrderDetail
-----------
OrderNumber
PartNumber


SupplierPartNumber
------------------
SupplierNumber
PartNumber
SupplierPartDesc



I link OrderHeader & OrderDetail on OrderNumber

To link to the SupplierPartNumber table I need to link from:

OrderDetail to SupplierPartNumber using PartNumber
and OrderHeader to SupplierPartNumber using SupplierNumber

Crystal complains and says that there are multiple paths to the SupplierPartNumber table.

How to do this?

Appreciate the feedback.

 

[dgillz]

You do not need your last link. The link from OrderHeader to OrderDetail, and then from OrderDetail to SupplierPartNumber should be sufficient. Software Training and Support for Macola, Crystal Reports and Goldmine
251-621-8972
dgilsdorf@mchsi.com