i am developing a small db which has the following requirement...
A product cost can be created for a future year/month. All transaction before that date use the current cost. All transaction after that date will use the new cost.
If i have my product table with a cost field in how do i create a table that uses the above rule? i.e. the cost will change based on future cost changes.
hope that makes sense.