AnsweredAssumed Answered

Students and Courses showing one Portal based on another Portal

Question asked by pademo57 on Jul 9, 2016
Latest reply on Jul 9, 2016 by Extensitech

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?