log modifications

[Benet]

im trying to create a log of modifications to a record, not what was done but just by who (user) and when (timestamp).

my initial thought was just to have a repeating field that went to the next repetition at each auto enter of the user modification and the timestamp.

problem is, the data overwrites instead of going to the next repetion and therefor creating a log.

can this be done or is my approach floored?

is there a simple answer ?

thanks

Ben

[Fitch]

Depends what you mean by "simple answer." IMO it's not all that simple, but it's not rocket surgery either. Start here:

Audit Trail Links

[Benet]

thanks.

Ive downloaded this file.

Im wondering if its something i can annex it onto my db's with a relationship and a few field name changes.

Maybe thats the way to go, it seems pretty comprehensive compared to what i ws after but that is no bad thing.

Ben

1142488509-AuditTrail-r4_0.fp7.zip