How to Avoid Cartesian Product

Question

I haven't used Access in a while and I guess I forgot how some of the basics work.  Ugh.  I have a setup like this.  All tables have 'Cost_Center'.  I was expecting to see 5 records returned, but instead I get 625 records.  What is the fix for this?

---

MY BOOK

Answer 1

I guess the Cost Center records in the 'Map_Unit_Prov_to_Unit_Recv' have to be unique, otherwise you'll get all kinds of dupe data.  It's been a while since I've done this, but that makes sense.  Is this right?

Thanks.

---

MY BOOK

Answer 2

Hi ryguy72,

please visit the links below will give you an idea how you can avoid Cartesian product in Access.

Access Query help: avoiding Cartesian product

Regards

Deepak 

---

We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
Click HERE to participate the survey.