I'm rather new to Access & I hope someone can help with a problem I encountered.
I'm designing a very simple database that tracks the amount, price, total cost, etc of raw material that we buy. If the price of an item increases over time, I know that I can just update the cost in my vendor table and it will cascade to my other linked tables and update the totals for our orders. Perfect.
The problem is, how to I ensure that I can keep an accurate records of past transactions at the previous price? In other words, I don't want my tables to update items purchased in the past.
Any guidance would be greatly appreciated!
MTmom
I'm designing a very simple database that tracks the amount, price, total cost, etc of raw material that we buy. If the price of an item increases over time, I know that I can just update the cost in my vendor table and it will cascade to my other linked tables and update the totals for our orders. Perfect.
The problem is, how to I ensure that I can keep an accurate records of past transactions at the previous price? In other words, I don't want my tables to update items purchased in the past.
Any guidance would be greatly appreciated!
MTmom