With reference to post #5, I am jdraw and did provide a sample database at AWF. The whole thread has a discussion of using data macros.
You might want to describe/provide an example of what you mean by "audit tracking". Typically you would have an audit table and a record for each change to...