I have 3 Tables GroupsName, StudentGroups and of course Students



I have Multiple students that correspond to only one Group name from GroupsName and I want to alocate this in a new table because one student can migrate to another Group so I'm having in mind one combo box that will show the GroupsName and a listbox from where I can chose the Students and for each student chosen I add the corresponding ID's in the StudentGroups Table!



How would this be done ? or Is there a simple wey to do this ?