Add record to multiple tables in MS Access

[CVesta81]

Hi!

I have an Access database with three main tables, "tbl1Customers (MASTER)", "tbl2Contacts (MASTER)", and tbl3Addresses (MASTER)". For simplicity purposes, I will refer to these tables as Table1, Table2, and Table3 respectively. I want to be able to add a new record to Table1, and have that record also append to Table2 and Table3, in order to be able to perform data entry in Table2 and Table3. Currently in my form, I cannot perform data entry because when I add a new record in Table1, it does not get added to Table2 and Table3 and I get an error message when I try to do so.

Currently I have a form for specifically creating a new record in Table1. When I close the form (OnClose) I want the other two tables to be appended with the same primary key information. In this case the primary key for each table (1 to many relationship) is a field called, "CustomerNo".

Let me know if you need any further information about my problem. I appreciate your help!

Chris V.

 

[SkipVought]

Welcome to Tek-Tips.

Pleas post MS Access questions in one of the many MS Access forums, like forum705.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[CVesta81]

Oh, sorry Skip. I thought this was the right forum. Thanks for your direction. I will repost...