hey guys, not sure if there's a simple answer to this.
I have a table storing information on materials, so material codes, descriptions, cost per unit etc.
I have a form relating to this table. I wanted to know, if I select a certain material code in one field, can the cost per unit for that...