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.

This tutorial is a follow-up to Tutorials 1-3. If you haven't read the previous tutorials yet, please do so before reading this tutorial since I won't cover the material that is the same as in earlier ...

Excel possesses formidable database powers. Creating a relational database starts with a Master table that links it to subordinates, called (awkwardly) Slave, Child, or Detail tables. Before we dive ...