how to create a record edit history/log

[mishel]

i want to create a record edit history/log.

what i have now is a timestamp that auto-updates itself each time something is edited in the record. what i'd like is for the time stamps not to be replaced each time the record is edited..

sorry just a beginner here.

[transpower]

Create an event table and a script. Every time the record is updated, post the date-time stamp (and the primary key) to a new record in the new table. But if you have a very active database, you will soon have a huge event table!

[Arrakis]

You can make an edit log field by creating a field with an auto-enter calc that's defined to take the field's current contents and append (or prepend) a new log entry (timestamp, user name, whatever). Make sure the auto-enter option is defined to overwrite existing values. Then you need to get this field to be triggered whenever certain other fields (or any fields) are modified. If you modify the calc to reference these other fields (without interfering with the result of your auto-enter calc), then this auto-enter field will be re-triggered whenever a user modifes one of those referenced fields. Lastly, if you reference a field which is defined with the auto-enter modification date (or similar) option then your dependent auto-enter calc field should also get triggered when the record is committed after *any* data change.