Update values in the table based on another table.

Update values in the table based on another table.

I have a table(Stock) where the values are populated from an import excel option (say 10 records). I have added an additional field in the form for ModelCode. Now the value for the ModelCode in the Stock Report is empty.

Another table(Products) has the value for ModelCode. Based on the condition as model no same in both the tables, i were to update values to the Stock table for ModelCode. 

Pls suggest me how can i do it..

Thanks in advance.