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.
Microsoft Access is a database management system program that combines the relational Access Database Engine with a graphical user interface and software development tools. In Microsoft Access, you ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results