>Suggestions:
>What do others do in cases like this? I am more looking for a concept more than a technical solution. It is sort of like we want to "close the books" then have an audit trail to track any changes.
>We certainly don't want to discourage anyone for correcting data since clinically we want to know what "actually" happenend.
We have situations something like this...what we do is keep an additional table of all the edits performed on the records, by table & field, with user and datestamp, and of course a keyfield for each table. You can then do other things, like doing a SEEK when users are browsing, etc., to show if edits have been done, and they can click (somehow) to see details, or even do queries on the edit table (really an audit trail)...
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.