As follow in to what Evan said, when I set up audit tables I include in the audit table the field that was being changed and if I am auditing changes on multiple tables then I include a field for the name of the table.
I then fire and automation to record both the old value and the new value into that table. Inevitably there are many records written where the old value and the new value is the same because I use one automation which many steps to write out separate records for the old value and the new value whenever anyone of a number of fields change.
So I know you said you had 100 fields but for example you could decide to track the 10 most important fields.
Then when the record is changed and just one out of those 10 fields change you end up writing out 10 records of which nine have the old value and the new value identical.
So then you can set up an automation to automatically delete audit trail records where in fact there was no change.
This approach works pretty well as long as you do not need to track every single field.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.commark.shnier@gmail.com
------------------------------
