What my wife wants is for a new record (or tuple, you know what I mean) to be automatically added to one of those tables when a record is added to the other table.

I am able to add records to a single table just fine, I am able to edit records in 2 tables just fine, however, I am unable to add new records to 2 tables at once.I have two tables, table1 stores ...

Create a Form for a Query or Table, Edit & Delete Data, Navigate through Records, Add & delete Rows and Records in a Form in Access.