Storing updates?

[ddiver]

Hi all

I have a database that stores customer records and their associated insurance details. I need to be able to track any changes made to that record within a set time period ie if details are changed fine it is reported next time report is run. But if details are changed more than once in between reports then first detail change is lost.

I would like to work out a way that changes can be written to a ??seperate version of the table?? and stored in there to be reported seperately and not just the final change as is the snapshot nature of a report? Is this possible? Could I possible make another version of the main table appended onto it? I feel I 'know' what I need to do but not how to even begin it! Any help would be appreciated.

DDiver

 

[neileg]

I would suggest that you add a new record rather than amending the existing one. Give it a time stamp and the most recent record will be the current one. You will also be able to report out a history of changes.