Hi all
A straightforward one I'm hoping...
I have a many to many relationship (TblStudents, TblTeams, TblStudentsToTeams). Students can be at 2 or more different teams and the teams can have 2 or more students.
I have created a form (where the user can navigate between the teams using a combobox and the arrows) containing a subform where they can view the members of each team.
When I want to create a new team, I can do that easily using the main form.
My problem is: when I am trying to add a student to a given team (using the subform) it creates a whole new team instead of using the existing one (there can't be spelling errors as I'm using a combobox). Any ideas??
Thanks in advance