Sorry, I forgot to include those that answered in the CC.
Thanks for everyones input.
My state office does not "buy" 3rd party software and I did not want to get into that much coding since I was only trying to archive as history for nothing other than on-demand display and I have to keep it maintainable(uncomplicated???). Our office wants to "keep it simple", so I opted to scatter current data to an array property as aOldVlaues on edit.click then insert appropriate data into a free table for on-demand display history on save.click.
Thanks again, Chuck
>>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