Hello Daniel, I have used a solution from the last century that I am happy with for quite some time:
A table tracks who modified/deleted what record of what table and when, and a related table listing the old/new values if modified fields. It lets me see: Who modified things daily, What Tables were modified, What Records of a table were modified, And what were the field values that were modified. This structure allows the boss to easily see who did what, and where. Creating a mirror table seems a bit of overkill. Jim Dorrance [email protected] [email protected] www.4d.dorrance.eu PS: If you know of anyone that needs an experienced 4D programmer to add energy and experience to their team, please let me know. I have experience in many areas. Reasonable rates. Remote or Paris only. ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
