Recently, our team is develop a student course application. We have student table, course table, and studentcourse bridge table. In a report page based on the course table, we want to add buttons named SELECT for each row (i.e. each course). If we click the SELECT button, the course_ID and student_ID will be added to the studentcourse bridge table. Could anyone provide some sample solutions to achieve this?
I have referred to the websites below but they do not work for our current scenario.
Thanks so much!
This sounds like a student exercise, right? If so, you should get help from your mentor.
In a pretty straightforward N:M situation like this, I would use a shuttle item. See this old, but still valid, example: