AnsweredAssumed Answered

Filtering Related Records Result

Question asked by APapaa on Mar 17, 2014
Latest reply on Mar 17, 2014 by APapaa


Filtering Related Records Result


     I have three tables. "students" for student details (name, mobile, etc.), "lessons" for the lessons they are following and "stud_less" for the many to many relationship (one student can have many lessons and one lesson can have many students). The last table also contains their degree for each lesson.

     I need a report that shows all students with degree < 5 that follow a certain lesson. In my script I use Go to Related Record but this returns ALL students that belong to lesson A for example. I need those with degree < 5. Is there a way to include this in my script?

     Many thanks.