paul.clarke
Registered User.
- Local time
- Today, 15:41
- Joined
- Mar 13, 2009
- Messages
- 51
I am looking into using some historic prices/rates to calculate values. The trouble is if the rates/prices change, the values will automatically be calculated on the new prices, Is there anyway i can use for example a rate from 2008??
Is not not an option to have a seperate database table for old rates, as there are far to many and change to often.
i.e "price" is generally a field on the "product" table, but as this is subject to change, i do want the cost of an old order based on a old price to change.
Any suggestions.
Thanks
Is not not an option to have a seperate database table for old rates, as there are far to many and change to often.
i.e "price" is generally a field on the "product" table, but as this is subject to change, i do want the cost of an old order based on a old price to change.
Any suggestions.
Thanks