Automatic Filling in of a field

[Fadius]

I am creating a database to track customers, product and orders. This is probably easy and I am just thinking to hard, but here is what I need. When filling in an order and a product is selected. I need the price to automatically fill in for the corresponding product. The Price and product are in one table, and the Orders are stored in another table.

SHould I just store the product and quantity ordered in the orders table and have the form perform the calculations? If I do that, what would be the best way of storing order totals?

Thanks in advance.

 

[bobbster2000]

Look at these threads for help

thread181-8559

thread181-58725

thread181-80164