Creating a Simple Log

[levi777]

I've seen a lot of examples for really good logging systems. They're very advanced and something that I would like to use. However, the database I'm building is based on a flat file database created in the early 80's. So we have some fields that contain A LOT of text. Keeping track of the actual changes to the field would basically make our database HUGE, which wouldn't be a big deal, but we use synchdek to distribute full databases to our sales team.

Here's my idea, let me know if I'm on the right track.

I want to track when any changes were made to a record, but not at the field level. I want to keep a running tab of who modified the db, as well as the date.

So I'm thinking something to the effect of if dateModified (which is a autocalculation set to date modified obviously) changes I'd write to a log field, but I'm not sure where I'd put this script. I don't want to attach it to a button. Any ideas?