I've been asked at work to create a small/simple database application for a week using Access 2003. So I need to learn basic MS Access and VBA to accomplish the task. I've currently ran into a little ...
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.