Dynamic Data: Filter non-primary key field on the List.apx page

Question

Student Table

UserId Name Surname

Results Table

ID UserId Year Symbol

Student has many results. There is a one-to-many relationship on the UserId fields.

---

I am using Dynamic data for my admin section. When I go to the list page for students in dynamic data, I want to be able to click on a Student and then view that Student's results.

At the moment, When i select a student, I get a list of all the Results in the database.