AccessDiscussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.
You are currently viewing the Access section of the Wrox p2p Programmer to Programmer discussion community. This is a community of more than 40,000 computer programmers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining our free Wrox p2p community you can post your own programming questions and respond to other programmers’ questions. Registered users also don't have to see the ads that are displayed to guests. Registration is fast, simple and absolutely free so please, join today!
Join today and post to win prizes! Post more to increase your chances of being Wrox’s top poster of the month.
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.
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.
Insert multiple records in a Inner Join Table
Linear Mode
