changes to data in table

[geet72]

Hi,

I am working on a insurance database. When changes are made to key fields such as policy start and end date, premium amount, I want the changes to be stored in a seperate field in the same table or have the old data to be saved to a new table before the changes take effect. This is so that I have the old value and the new value and can do any adjustments to journal entries.

Is there a way to do this. Any help would be appreciated

Regards
Geetha Ambarish

 

[neileg]

HAve a look at the Audit Trail thread in the General forum.