Hi Everyone,
I'm hoping someone can help me with this. I have a many-to-many relationship set up using a junction table. One of my parent tables is 'Employee Information', the other parent table is 'Projects'. We have multpile employees working on multiple projects (up to 19 projects). I have created a junction table where the emlpoyee ID number and project number are set as the primary keys. They are both the primary keys in the parent tables as well. The project numbers are currently set up as a combo box in the junction table.
What I am trying to do is create one form where I can enter all the information. So far, I have made the main form to be the employee information. I have created a subform using the junction table. I would like to be able to see which projects an individual is working on (could be up to 19). I would also like to add an individual to a project and that information be inputted in to the junction table. The issue I am incountering is that the combo boxes on the form will only let me select one project. I have tried creating multiple subforms and I have created individual combo boxes on one subform, but the same thing keeps happening. If I have say 5 combo boxes, all 5 will show whatever selection I chose in the first one.
Does anyone know how to allow for multiple selections?
Thank you for your help.