|I'm using microsoft Access 2007 and I'm trying to figure out something.|
I have a table called 'orders' which contains information about the customer and product etc. I also have another table called 'products' containing information about the product.
One of the fields that needs to be filled on the order form is 'Product code' and another one called 'Cost of item'. When the user fills in the product code how can I get access to automatically fill in the field 'Cost of item'?
I hope that makes sense!
To clarify, bascially how to i get one field to be filled in automatically based on another field in a DIFFERENT table?