Assign a price value to a list of products
I am trying to design a database which has a list of products and a list of prices.
Baically I have a list of about 20 different products and I would like to assign a price value to each one of the products.
The idea here is that when I enter data, I can have a pull down box where I can select the product I want and in the next field, it will auto enter the price. This will save time having to enter a price every time I enter a product.
I am sure it is possible to do this but I am not sure how to get it working. I woould be grateful if anyone could help.