Copy column from one table to another with relationship

Hi,

  I have 2 tables below with a relationship between the Order_no in the Model.  For each Order_no I want to copy the Unit colum from the first table to the second based on the Order_no being te common parameter/relationship.

Regards

  Ian