Too Many records showing up

[SAC]

I have three tables that I'm trying to make work in a query: SalesOrders,
CrossReference, PurchaseOrders.

The CrossReference Table has SalesOrderNumber, FactoryPurchaseOrderNumber,
and CustomerPONo in it.

(I didn't design the system...just trying to work with it the way it is.)

When I make a query using SalesOrders and CrossReference related by
SalesOrderNumber for a particular CustomerPONo, I get 4 records.

Likewise, when I make a Query using FactoryPurchaseOrder and CrossReferece
related by FactoryPurchaseOrder for a particular CustomerPONo,. I get 4
records.

However, when I use all three tables in a query I get 16 records.



Table A------Table B = results in 4 records

Table C------Table B = results in 4 records

Table A------Table B------Table C = results in 16 records.

I've tried all the different join properties and still get 16 records.

I've also tried using the first two queries as data source in a third query
but still get 16 records.

For each result I'm getting all the records of the other table.

How can I get only the four records?

Thanks.

 

[Jeff L]

Are you linking your Customer PO Number fields together too? In
reading what you wrote, it sounds like that may be the issue you are
facing if the Customer PO Number fields are not linked.

 

[SAC]

That worked. Thanks.