Populating Fiends

  • Thread starter Thread starter SteveH
  • Start date Start date
S

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
 
Back
Top