Archive records

  • Thread starter Thread starter Bruce McKenzie
  • Start date Start date
B

Bruce McKenzie

I have a products an order and order details table.
I want to be update prices in my products table but not
affect any previous order prices.Has anyone got any
ideas.I am a new user.
 
Bruce McKenzie said:
I have a products an order and order details table.
I want to be update prices in my products table but not
affect any previous order prices.Has anyone got any
ideas.I am a new user.
Click to expand...

In that case, you would want to store the price at the time of the order in
the order details rather than picking it up from the products table whenever
you needed it to use in a calculation.

Larry Linson
Microsoft Access MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiple Price query based on customer type 18
Auto Fill Fields for Order Entry Detail 2
VBA - retrieve data on last create named range from previous inserted named range 0
single report page per customer 7
adding records to a sub form 2
Inventory/Sales/Warehouses 6
history of prices table 3
Help with design structure 2

Back
Top