I'm trying to incorporate the Audit Trail as shown by Martin Green http://www.fontstuff.com/access/acctut21.htm
The audit table is working fine but I'm having a problem matching up the audit recordID field with the underlying table ID field in a meaningful way. How do I join both tables in a query so that I can add a field from the underlying table to help identify the record.