I am trying to build an Inventory system for our company for the types of paint we use on a daily basis. I want the user to be able to go into a form and select a product and choose which vendor that product is from. I set up a Many to Many relationship between the Products and Vendors, so I have a junction table between ProductT and VendorT called VendorXProductT. In this table, say ProductID could have VendorID 2 and 5. So the same product could be selected from either Vendor 2 or 5. I want this to function this way in my form. Right now I'm running into an issue where if I set up a standard combo box for a vendor from the VendorT table, that does not link with my Product Code in my Form. So I looked into this issue, and I realized that I have to link the ProductID with VendorID in that form. What I did was I created a Query which shows the ProductID and the VendorName associated with that ProductID. So it lists all the Product IDs and VendorNames, right next to each other. However, when I put a combo box into the form, I can now select a Product Code and Vendor, but it does not limit me to the Vendors that are only associated with that ProductID. So I get a full list of vendors that show up multiple times in the Vendor combo box.

How do I limit the Vendor Combo box to vendors that are associated only with that specific Product Code (Product ID)?

I have an image below of my form and table design and it's relationships. I hope I did it ok, since I'm a novice user.

Also, I watched All beginner and up to Expert 8 so far from the Access Tutorials, so I'm kind of basing my knowledge from those tutorials. Please let me know which tutorial to watch if this is covered in one of the tutorials. Thank you.

http://tinypic.com/r/33e3q7c/8

---

Reply from Richard Rost:

On which form is the vendor combo box that you're having trouble with? If it's on the product form, then you have to show ALL vendors because that's the way you CREATE the relationship of which vendors are associated with which products.