Copy column from one table to another with relationship

[Pick]

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 

[vanessafvg · Accepted solution]

have you tried in a new column

column =
RELATED ( [table2].unit )