I have students and books, they are in many to many relations with eachother so I created a third table that will record the owners of the books. So far so good and I can put up the relations.



So I got:

Table Book: BookID, data
Table Student: StudentID, data

Table Owner: OwnerID, BookID, StudentID

Now I would like to put up a form that will allow me to add data into the owner table. I would like to make 2 drop-downs with the fields from book and another drop-down from student. So far so good. Now to my problem. I would like to make a button so when I press it the two rows shown from the two dropdowns primary keys will be stored into owner.

All help is welcome.

I will try to add my database here as well.