Creating a form for a Junction/Intersection Table

[aproctorpe001]

I'm trying to create a form that will enter information into a junction table. I have a many-to-many relationship between two tables: Events and Contacts. The purpose of this form is to assign people in the Contacts table to a particular event. Ideally, I would like to be able to see an event record on one side of the form and a list of Contacts on the other side of the form and by double clicking the Contact record while the current event is selected will insert a record into the Junction table indicating that that Contact has been selected for that event. Any ideas of where to start?

 

[Travis]

List box control
and an Append Query based on the selected item in the List Box Control