Populating Fiends

[SteveH]

I have an item table with an item code, last cost, and average cost. I have a
second table that contains order information. In the order table, I have a
combo box lookup that shows the item code. When the item code changes, I
would like to update the average and last cost fields in the order table with
the cooresponding data from the item table. Any suggestions on how to do this?

Thanks

 

[SteveH]

I meant Fields. Sorry