4 Replies Latest reply on Mar 17, 2014 2:56 PM by APapaa

    Filtering Related Records Result

    APapaa

      Title

      Filtering Related Records Result

      Post

           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.