Bound Combo Box issue

[jbaccess]

I am creating an inventory / shipping database system for a local non-profit.

I have it almost done, but when I select the vendor to ship to (via a combo box), all products (regardless of time) of that type are changed to the vendor selected.

I need to be able to have multiple vendors for multiple products. In my relationships I have the vendors linked to the inventory, but obviously wrong. We are tracking individual pallets, so it is very possible that a several pallets of product A can be shipped to two or more vendors during the same time period.

The Combo Box is bound to column 1 which is the inventory transaction id number.

Thanks in advance

 

[Alansidman]

Your combo box should probably be linked (recordsource) to a table that has only the Vendor information in it and not the transactions. A separate table for the products with a one to many relationship between the vendor table and the products table.

Alan

 

[jbaccess]

worked!!! yeah! and THANKS!