I have a products database, i have made a products table, Materials Table and a Magazine Table. I have multiple product that use multiple materials.  I created a list box to show the materials for each product, but it's double each materials twice or three times. some help please.

---

Reply from Alex Hedley:

Sounds like a cartesian query, have you created a junction table that shows materials for product and that's the one you're using?
Or do you need to filter the query with the material id?