RickK Posted December 3, 2002 Share Posted December 3, 2002 First let me say thanks to all of you who created and posted audit solutions on the forum. Your ideas gave me the insight needed to create a solution. Now it's time to pass it along to someone else who may be able to use it. This 'Audit_Trail' solution is currently operating in several of our databases (as an admin level layout..and working very nicely). NOTE: FM version 5.5 + is required to return the text for field contents, earlier versions return a '0', all other info is captured. File is .zip format.. Audit.zip Link to comment Share on other sites More sharing options...
Ocean West Posted December 4, 2002 Share Posted December 4, 2002 Rick Try again the file didn't get attached. Link to comment Share on other sites More sharing options...
RickK Posted December 5, 2002 Author Share Posted December 5, 2002 Sorry about that. See attachment Link to comment Share on other sites More sharing options...
Dr. Logan Posted December 22, 2002 Share Posted December 22, 2002 Very helpful... Thanks Rick! Link to comment Share on other sites More sharing options...
macguys Posted April 23, 2003 Share Posted April 23, 2003 It works well, except for two things. 1. I can't seem to find a way to capture the original value. 2. When I create a new record, the change capture only works after I have left the original record and returned to it. Link to comment Share on other sites More sharing options...
BobWeaver Posted April 23, 2003 Share Posted April 23, 2003 The problem with every audit trail solution I have seen is that it doesn't work when the record is first created. If you script your record creation, then simply include an 'exit record' step immediately after creating the record. Otherwise, you will have to be satisfied with only the subsequent changes being captured in the audit trail. Link to comment Share on other sites More sharing options...
Recommended Posts