I have a many to many relationship database in Access 2016 between books and genres as an example case. The problem I am running into on my Book Form - Genre Subform setup is in trying to use multiple genre combo boxes (let's say 3) that have the genreID control source to have a different selection in each (e.g. combo box 1 select Fiction, combo box 2 select Fantasy, combo box 3 select Romance). Is there a way to have that set up where the genreIDs selected can relate back to a single bookID?
Also, I have been able to somewhat do this with a multi valued field, but I would really like to avoid using that if at all possible.
I have attached pictures for some reference.