How to create a trigger to log changes made to data in one table

[superfloss75]

Hello,

 

I am very new to FM and I have been asked if audit logging of changes to data in a single table can be achieved. From my Googling, it appears that it can be done (im using FileMaker Pro Version 10.0), by writing a script and having a trigger fire each time the data in the table is modified

 

My question is this : how exactly do I go about this ? Ive searched for examples online but havent found anything relevant to what Im trying to achieve. Any feedback / direction would be greatly appreciated. Thanks.

 

The structure of the table I have to work with is as follows & the fields that data would be changing in via user modifcation are "Action" and "Conclusion".

 

CPD_CPR_H table

 

ID

Mandate Number  Text

Mandate Title   Text

Title                 Text

Response1     Text

Response2     Text

Scope             Text

Action              Text

Conclusion     Text

 

Audit_Table  ( // structure I was thinking of having but am open to any suggestions / alternatives ! //)

 

ID

Date

User

Field

Original_Value

Updated_Value

[dansmith65]

Have you searched the forums for this topic?  I believe there was a discussion on this topic within the last 3 months.  Sometimes it's more reliable to use a google search: https://www.google.ca/search?q=change+log+site%3Afmforums.com