Hi Guys,
I'm having a bit of an issue... I need some code to loop through the records on two separate tables and update the records accordingly.
I basically need the code to loop through the testing table and check the product against the free stock in the free stock table. If there is sufficient free stock then i need the 'Qty Req New' column to be the value from the 'Qty Req' column and amend the include value to -1.
I then need the code to go back to the free stock table and update the quantity taking off what is in the Qty Req column for that design in the testing table.
I need it to loop through and do this for all records in the testing table.
Images of the table are as below, i wont post my code as frankly its a mess and this has taken me quite some time.
Thanks
Rob
I'm having a bit of an issue... I need some code to loop through the records on two separate tables and update the records accordingly.
I basically need the code to loop through the testing table and check the product against the free stock in the free stock table. If there is sufficient free stock then i need the 'Qty Req New' column to be the value from the 'Qty Req' column and amend the include value to -1.
I then need the code to go back to the free stock table and update the quantity taking off what is in the Qty Req column for that design in the testing table.
I need it to loop through and do this for all records in the testing table.
Images of the table are as below, i wont post my code as frankly its a mess and this has taken me quite some time.
Thanks
Rob