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.

A database can grow larger, especially when you add more data to your databases. Access databases can occasionally become corrupt or damaged or deleting objects such as records, tables, forms, or ...

Ok, I'm at a client site where they want to make a program database independent. This is a rewrite of an existing program that used an Access database only. I asked the person in charge how they were ...