Hilmar,

>I am thinking about designing an audit system (for tracking changes to tables). The auditing in the framework I use has certain limitations, and I want to build an improved audit system.

Unless you just enjoy re-inventing the wheel, get FoxAudit:

http://www.takenote.com/foxaudit.htm