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.<BR><BR>I have two tables, table1 ...

In Microsoft Access, you can add records to an existing table that already as data and resize the columns that contain the fields and data, especially if there is not enough space within the columns ...

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.

Microsoft Access is part of the Microsoft Office Suite of home and business solutions. Those with MS Office 365 on a PC should have access to MS Access 2016. If you are working with an older version ...