Assign primary supplier?

Hi, I've just removed en masse a primary supplier that was attached to every item in my test database hoping that the single remaining supplier for each item would default to being the primary. Unfortunately, that wasn't the case and I'm wondering if anyone can help with putting a statement together that will turn on the tick box for primary supplier on the Supplier tab within Item properties. I'm having trouble finding anything relating to primary supplier in the actual tables. Thanks.

Reply to
Tara
Loading thread data ...

UPDATE Item SET SupplierID = SupplierList.SupplierID FROM SupplierList WHERE Item.ID = SupplierList.ItemID

In the SupplierList not exist a column to identify the primary supplier...

cod

Reply to
cod

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.