Junction Table\

[Akitt23]

Hi Guys,

I am new to this forum so any help would be very much appreciated.

I have 3 tables:

Candidates
Event
Junction table

I am using the junction table to provide a link between candidates and events.

My aim is to produce a form that can select an event and then select a candidate and assign them to an event.

A candidate can be apart of multiple events.

I am struggling on how to create the form and i have no idea where to start!

Thanks in advance

[June7]

Use a form/subform arrangement. Options:

1. main form bound to Events, subform bound to Junction, combobox to select candidate

2. main form bound to Candidates, subform bound to Junction, combobox to select event

or a single form bound to Junction with two comboboxes to select candidate and event

[Dal Jeanis]

I hope your Junction table has a more meaningful name (like SchedToAttend).

June's option 1 is the right one for your specific question, if you are already confused.

There are also some more advanced interface options available:

4. Main form bound to Event. Left Listbox 1 of all candidates currently assigned to the event (source is Junction table). Right Listbox 2 of all candidates available to attend (source is candidates table, minus any candidates in Listbox 1, minus any candidates with scheduling conflicts). Double-click on candidate in right box to assign to event, doubleclick on candidate in left box to remove from event. (I usually also have four buttons for add all, add selected, remove selected, remove all.) This method requires some VBA and SQL knowledge, but it makes for a great and very convenient user interface.

[Akitt23]

Thanks for the quick response!

I will try the first option and let you know how it goes

The advanced option looks very user friendly. Do you have a sample database Dal?

Thanks for you time

[Dal Jeanis]

Unfortunately my working db with that interface would take way too much 'splainin.

I'll have to simplify it a bit, and post as a sample, when I get the time.

[June7]

Another recent thread on syncing two listboxes https://www.accessforums.net/program...2-a-39302.html