Junction Tables - Allowing multiple selections on form
I need to be able to show a person having multiple roles in an event. I have a table for guests,roles and a junction table for guestroles. One guest may have multiple roles and one role can be held by multiple people.
I am in the layout stage now and I don't know how people will be able to chose more than one role. I have created a drop down box.
Thank you in advance for your help.