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 ...
How to create a Form for a Query or Table, using Form How to Edit and Delete Data in a Form How to Navigate through Records. How to add and delete rows and Records in a Form Shantel has studied Data ...