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