I have two tables: "Delivery times" and "Receiving Times"
Both are joined by the PO number and the relationship Join Type is set to include only rows where both are equal.
Where the PO number matches, I want to include these rows. However there can be multiple instances of the PO number in each table.
Right now, For each row in "Delivery Times" the query is including every row in "Receiving Times," multiplying the result!
Example:
"Delivery Times"
1234567 | X | Y | Z
1234567 | X | Y | Z
1234567 | X | Y | Z
1234567 | X | Y | Z
"Receiving Times"
1234567 | A | B | C
1234567 | A | B | C
Query Result:
1234567 | A | B | C | X | Y | Z
1234567 | A | B | C | X | Y | Z
1234567 | A | B | C | X | Y | Z
1234567 | A | B | C | X | Y | Z
1234567 | A | B | C | X | Y | Z
1234567 | A | B | C | X | Y | Z
1234567 | A | B | C | X | Y | Z
1234567 | A | B | C | X | Y | Z
Expected Result:
1234567 | A | B | C | X | Y | Z
1234567 | A | B | C | X | Y | Z
How do I force Access to include the total number of combinations and not permutations?