Looking up data

  • Thread starter Thread starter Jayne
  • Start date Start date
J

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
 
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.
 
Back
Top