I have 3 tables: Students, Courses and a join table called j_Student_Course, because a Student can have many Courses and a Course can have many Students.
Because each student has to have a report written each day on their behavior I then added a new table called Reports and connected it to the join table j_Student_Course.
My problem is when I have a Course layout which shows in one portal all the Students, I would like to click on a Student portal row and in the second portal show only the Reports that Student has.
First of all, is this possible? If so, how do I get this to work? I tried putting a global field in Students and then tried to connect it to the Reports table but it doesn't work.
Secondly, is there a better way to do this? Specifically, have I connected the tables correctly or should I do it another way?