I have a table of data for a school schedule that has columns for teachers, courses and students enrolled in those courses. (Therefore, the number of rows I have in total is the number of course-students.)
I would like to create one view where a user can see a list of teachers and drill into the list of courses they teach and then tap a course to see the roster of students enrolled. The way I have the data though, when I first tap a teacher I see each course listed 30+ times in the table since there’s an entry of that course and teacher for each student in that course. How can I only show a discrete list of courses when I tap on the teacher and then the roster when I tap on a course?