How to create a modification history file?

[norwood]

I want to create a function in which we can track the last modified date, time and name in a specific file in a database. We currently have modified date, modified time, and modifier name fields (updating as auto-enter definitions) in the file itself, but we want these to show through a portal as a "history" sorted by decending date.

Is there a way to set up an external file so that each time a record in the specific file is modified a new record is created in the relational file that tracks the last date, time and modifier name? Using FM 5.5.

Thanks for any suggestions you might have.

-Matt Norwood

[norwood]

Or know any plugins that might assist in this?

[Lee Smith]

Hi norwood,

This topic comes up all of the time. You can do a search for Audit Trail, Field Modification, Field Modification Tracking, etc. and you will be overwhelmed with information.

Here is a recent thread on this topic you might find useful.

http://www.fmforums.com/threads/showflat.php?Cat=0&Board=UBB26&Number=105985

HTH

Lee

[norwood]

Thanks, Lee. I looked through and found a bunch of options. The database pros option works best; it's simple and effective.

Matt