Data Entry Issues using Form with 3 linked Tables

[CVesta81]

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, the primary keys do 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" and "Organization No".

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

[June7]

You say 'append to Table2 and Table3' - are you duplicating records? Or do you just want the primary key of table 1 saved as foreign key in tables 2 and 3? Have you considered form/subform arrangements?