Hi! p2p to all experts.

I have a exsting table tblMain and tblMainSub.
tblMain is my Main and tblMainSub is the sub table.
I used one to many relationship. I have Inner Join between the Field CompanyID in tblmain and CompanyID in tblMainSub to Visualize my table structured.
tblMain
=======

CompanyID Autonumber
Company Text

tblMainSub
==========
CompanyID Number
Contact_Name Text

Im poluating the records in MS ACCESS using Subform. therefore the CompanyID field in tblMainSub automatically updated.

Now heres the my problem want to ask I want to insert multiple records in that two tables.


I used Inserts using Sub-Select but it doesn't work.

Appreciate all you help

Thanks
Rylemer

As far as I understood your problem, u will be able to insert a new Contact_Name only if he is related to a Company. No unrelated Contact_Name would be allowed, only a Company without a related Contact_Name. An independent table non related Contact_Name would solve the problem.
Trully Penta.