LittleJess
MIS
I am trying to create a contacts database I have created a form with personal details such as Name, Tel, Fax etc and on this form I have included a subform with Location (Address 1, 2, 3 Postcode etc) In order to create 1:M instead of M:M (People may have many locations and locations will have many people)relationships between the tables I have created an in-between table containing just PeopleID and LocationID.
I am having real problems working out how to send the people ID and the Location ID from the form to the In-Between table so as to create a link. I have tried cmd.RunSQL and various staements but am having no luck.
I would greatly appreciate anything anyone could suggest to populate this linking table.
I am having real problems working out how to send the people ID and the Location ID from the form to the In-Between table so as to create a link. I have tried cmd.RunSQL and various staements but am having no luck.
I would greatly appreciate anything anyone could suggest to populate this linking table.
