Assign primary supplier?

Aug 20, 2007 1 Replies

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.


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

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required