You can view an Access database as a collection of related tables. A table in Access is a subject-based list of rows and columns. Each row in a table is called a record while every column is called a ...
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.
Some results have been hidden because they may be inaccessible to you
Show inaccessible results