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

Rick

Try again the file didn't get attached.

Sorry about that. See attachment

Very helpful...

Thanks Rick!

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.

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.