aleksmi
asked on
locked value
I wish to make sale database ( see attached testdb) . Problem is that when I change price of products in tblProducts , value of field price changes in all records ( new and previous) in qrySalesdetails .
I need advice as what I should do to keep saved records of sales with new and old prices .
While awaiting your reply,
Kind regards,
DatabaseTest.accdb
I need advice as what I should do to keep saved records of sales with new and old prices .
While awaiting your reply,
Kind regards,
DatabaseTest.accdb
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Please see the second paragraph in my comment http:#a39171150. What I discussed there is the same thing as you cite from the Northwind sample database.
ASKER
Thank you. I will try to "break down" the details form Nortwind sample database in order to try to figure it out.
ASKER
it seems that you solution http:#a39171150. is bit too much for me at this time. would you be able to advise me where i could see recommended solution done step by step ?
ASKER
It will work but I was looking for simpler solution like in "Northwind" where price is kept in table Products but if there is new price in table OrderDetails both(old and new) are being kept. I hope my comment made some sense to you