product price

• Question

• 

  

  0

  Sign in to vote

  What is the best thing to do with a product price

  I have product list with the price stored in it .

  because the price can change I think I can do two things

  1. store the price in a seperate table with something like a datevalue in the key
  2. if the order is done , transfer the order records to another order file , where i store the product price too

  which method is the best ?

  is there another method ?

  Saturday, March 15, 2014 8:52 AM