Hi Richard. Thank you for the reply. I actually figured out with the help of another forum. Your information is great and it works for a certain type of situation, but what I was going for was a form where I have concatinating combo boxes for many-to-many tables. Where I went wrong was that my inventory table didn't have a VendorID, MilSpecID, parts, which were in the many-to-many tables. Therefore the whole combobox that I set up within my inventory form was not functional because I was referring to the wrong fields and my form became non-editable. To fix it, I added the VendorID and MilSpecID into my Inventory table, and then proceeded by creating two queries which would be specific to the form's ProductID filed. So whenever a Product Name is selected from one combobox, the next combobox gets updated with the related fields only. I used your free concatenated combobox tutorial for that. I'm very pleased with the results.

For your example, you're allowing one customer to be in multiple groups but for a product inventory this would not work, because one product with a specific BarcodeID, cannot have two separate vendors. This way I can track one product from one vendor with a different barcode and the other same product maybe from another vendor with another barcode. I hope this makes sense.

Thank you for all the help.

---

Reply from Richard Rost:

Makes sense now. It's so difficult to understand what's going on without seeing the database - or at least understanding what you're trying to do. That's the hardest part of helping someone... trying to understand the problem. Every business is different.