I am having a time trying to devise a way to track changes to a table so that the user can see what pieces of a record changed, by whom and when. I was going to create a table to archive record changes to so that the user could click a button to browse(noedit) all changes to that record. I don't know if this is the best way and trying to determine how to keep before and after changes.
I have looked for other threads here and other sites but can't see to ask the right search question.
Any help is appreciated, Chuck
Extreme Programming = Plan -> Design -> Code -> Test