Keeping a history of records

[Lusitan]

Another doubt I have is:

I have a form to register applicants data. In it, there are the fields:

Candidate_Id
Candidate_Name
Candidate Address
…
and with the Candidate_Id filled in, it opens other tables concerning Professional Experiences, Literary Abilities and other Abilities.
What I need to know is how can I get to know if any of these data (including address, other abilities and others) been altered and how to list that. OR how to present a report or something of the last change for all the candidates.

Thank you

 

[doran_doran]

Audit Trail...

Please see attached database to monitor your data and trail or track what is being done. Good Luck.

Dianna Goldsberg

 

[doran_doran]

Advance Audit Trail...

This sample database is even more advance than my first post. Check it out at you leisure.

Regards
Dianna Goldsberg

 

[Lusitan]

Thank you. I'll investigate.