Updating a second record based on changes to first record

yahya · Post by **yahya** » Thu Mar 07, 2013 9:33 am

Run into a dilemna not sure how to update a secondary item when updating the first record, need some clues.

Am working on stock management transferring stock quanties from one product warehouse to another product warehouse.

Am presuming I would need to first find the related record which will go something like this:

FIND ProductControl WHERE StockTransferLineItem.Items.ItemCode=ProductControl.ItemCode AND StockTransferLineItem.DeliverTo=ProductControl.Warehouses

However once find how do I get the item updated with a new stock quantity, would imaging something like:

SET ProductControl FROM StockTransferLineItem WITH ProductControl.CurrentStock=ProductControl.CurrentStock+StockTransferLineItem.Quantity

But I know this is wrong just looking for the correct way, any assistance would be greatly appreciated.

pbrad · Post by **pbrad** » Thu Mar 07, 2013 11:28 am

Hi,
All you need is:

ProductControl.CurrentStock=ThisProductControl.CurrentStock+ThisStockTransferLineItem.Quantity

Cheers,
Pete

yahya · Post by **yahya** » Thu Mar 07, 2013 4:39 pm

Thanks for the feedback, worked like a bomb.

And I now got to see how to apply a This,

pbrad · Post by **pbrad** » Thu Mar 07, 2013 4:43 pm

No worries, you might also want to modify your FIND statement slightly from:

FIND ProductControl WHERE StockTransferLineItem.Items.ItemCode=ProductControl.ItemCode AND StockTransferLineItem.DeliverTo=ProductControl.Warehouses

To:

FIND ProductControl WHERE (StockTransferLineItem.Items.ItemCode=ThisProductControl.ItemCode AND StockTransferLineItem.DeliverTo=ThisProductControl.Warehouses) IN BATCHES OF 1

Cheers,
Pete