Insert multiple records in a Inner Join Table
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.
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