Using a trigger to update those fields works great, and at the same time why don't you write the inserts/updates/deletes to an audit table tracking the old and new values. ...