I do not believe Jet (the database engine Access uses) supports table-level triggers, so you'll need to use a macro or VBA code in a form to trigger the extra record.

I'm not sure if that's the right term, but how do I list records that are <B>not</B> matched to records in another table? I am joining 2 tables right now, tblPerson and tblHat, which are designed and ...

Did you know that you could calculate fields in the query in Microsoft Access? If the user wants a calculated field in a query, the user needs to input a name for the calculated field, a colon, and ...