Moving ILC for Standard Items into Reorder Number field

Posted by Kris on February 28, 2006, 9:26 am

Please log in for more thread options

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!
--
Kris

Posted by Rob on March 2, 2006, 12:50 pm

Please log in for more thread options

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:

> 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!

> --

> Kris

Posted by Kris on March 3, 2006, 12:28 am

Please log in for more thread options

Rob,
It worked perfectly. Thank you very much!
--
Kris

"Rob" wrote:

> 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:

> > 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

> > Standard items?

> >

> > Thanks in advance!

> > --

> > Kris