Moving ILC for Standard Items into Reorder Number field

Feb 28, 2006 2 Replies
K

I'm using the following commands to fill the Reorder Number field on Matrix Components with the ILC from the Matrix Parent and it works well...



UPDATE SupplierList SET SupplierList.ReorderNumber = ItemClass.ItemLookupCode FROM SupplierList INNER JOIN ItemClassComponent ON SupplierList.ItemID ItemClassComponent.ItemID LEFT JOIN ItemClass ON ItemClassComponent.ItemClassID = ItemClass.ID



This leaves the Reorder Number field blank for all of my Standard items. What coding would I need to fill the Reorder Number field with the ILC for my Standard items?



Thanks in advance!


Vote
Twitter Facebook LinkedIn
R

Run this query, this will change all items to have the ReorderNumber equal to the ItemLookupCode, then run your other query, that will change all Matrix Items ReorderNumber back to Matrix ILC.

UPDATE SupplierList SET SupplierList.ReorderNumber = Item.ItemLookupCode From SupplierList INNER JOIN Item ON SupplierList.ItemID = Item.ID

Rob

"Kris" wrote:

Vote
Twitter Facebook LinkedIn

Join the Discussion

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

Didn't find your answer?

Ask the community — no account required