If the records are to be added one at a time, you could write an Access form and then on the form's After Insert procedure add the other record to the other table. In this way, the After Insert ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results