Create Log Field
I would like to know how can I create log field.
I want to track the changes made to a customer's record and to be reflected in another field (log field), for example to have comments like these:
01/01/2010: record created
01/02/2010: field "whatever" changed to "whatever"
01/03/2010: field "whatever" changed to "whatever"
and so on
or something like that.
Thanking you in advance.
There are several techniques and plug-ins which handle audit logs.
For FM-native approach, I would suggest UltraLog by Ray Cologon, PhD. http://www.nightwing.com.au/FileMaker/demosX/demoX01.html
For plug-in, I would suggest FMDataGuard http://www.worldsync.com/fmDataGuard/
You can create your own solution if using FM11 (and script triggers) but you must be advanced to really understand how to pull it off.