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