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