Looking up data

[Jayne]

I have a table that lists products and prices. I have
created an order form to raise orders of these products.
When I pick a product I want it to automatically put the
correct price. However the prices may change halfway
through the year. What is the best way to do this?

thanks

 

[Ken Snell]

You need to give us more information -- such as how are you storing price
data in the database? How will the database know what is the "correct"
price?

What you seek to do isn't difficult, but you need to give us more details.