Flag if the field has been changed?

[BikeBoy]

Hi guys,

I want to show if the data in an individual field has been changed, or deleted, and who changed it. I know in FM there are several prebuilt fields, like "Modified By", and "Modified On", but these operate on a row, not just one field.

In other words, when a user changes ANY field in a record, user's name will show.

Is there an easy way to accomplish this? I can think of some complex scripting (Yaiks), but maybe there's a better way?

Many thanks.

[Lee Smith]

Hi Bikeboy,

This isn't that hard to set up, here are some example files on how to do this.

Modification Log By: John Mark Osborne URL:

http://www.databasepros.com

Field Modification Tracker By: Bob Cusick URL:

http://www.fmfiles.com/tnt2.html

Tracking Modifications By: Steve Wilmes URL:

http://www.fmfiles.com/tnt2.html

Field Modification By: John Mark Osborne URL:

http://www.fmfiles.com/tnt4.html

Comprehensive Audit Tracking System By: Ray J. Cologon URL:

http://www.nightwing.com.au/FileMaker/

Lee

[BikeBoy]

Thanks so much, I will check those out