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
