Unanswered: How to insert primary keys from two tables into an intersection table
I need to insert the primary key fields from two tables into an intersection table between the two tables.
The first table is called tblUsers, the second table is tblGroups. The two tables create a many-to-many relationship - One group can have many users, and one user can be a member of many groups. The intersection table is called tblLinkUsersGroups.
I am displaying details from tblUsers and tblGroups each in their own listboxes on a form. I want to select a User and then select a Group and click a button to add the primary keys from each into the intersection table.