# \[Help needed\] People evaluation and many to many relationships **URL:** \ **Category:** Ask for Help\ **Created:** [August 12, 2020, 4:08pm UTC](https://community.glideapps.com/t/help-needed-people-evaluation-and-many-to-many-relationships/13892 "2020-08-12T16:08:34Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![Abdelghafour\_Benkass](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/abdelghafour_benkass/32/1694_2.png) [@Abdelghafour\_Benkass](https://community.glideapps.com/u/Abdelghafour_Benkass)\ **Post date:** [August 12, 2020, 4:08pm UTC](https://community.glideapps.com/t/help-needed-people-evaluation-and-many-to-many-relationships/13892/1 "2020-08-12T16:08:34Z")
Hello, I’m new on Glide and am struggling to achieve something that seems simple enough. **The use case** During a pre-enrollement day for a school, would-be students are evaluated on different criteria during different activities by coaches. **The data** There are 4 tables: - Students: name, email, coach name, coach email - Activities: name - Criteria: name - Evaluations: evaluation, student foreign key, activity foreign key, criteria foreign key A student attends multiple activities An activity has many students An student has multiple evaluations (if there are 2 activities and 3 criteria, he will have 6 evaluations) **My UX** I planned on something very simple like this ![GlideTestWireframe](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/9/9dab88b8076ca11a0aff08f695d53d070985b8c0.png) **What I’ve tried** I have a table with my students, a table for my activities, a table with attendance (=link between student and activity) and a table with my evaluations with criteria, evaluation and attendance foreign key. I have managed to make the first screen work. For the second one, I can show all students attending the activity. **What I’m struggling with** How can I filter the evaluations table to only show those related to a specific student/activity couple ? I would have loved to use a simple evaluation.activity\_ID = selected\_activity && evaluation.student\_ID = selected\_student but I can’t make sense of the context variables in the filters. I’ve tried so many things on the app that it’s turned into something I can’t really show. If my explanation is not clear enough, I can tidy the app and share it here 🙂 Thank you ! ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [August 12, 2020, 5:05pm UTC](https://community.glideapps.com/t/help-needed-people-evaluation-and-many-to-many-relationships/13892/2 "2020-08-12T17:05:08Z")
If you’re planning to let people have a multi-filter screen then you can use the in-app filter feature for the evaluations screen, then use a combination of student ID & activity as the filter column. If you don’t want to join the 2 columns together, you can add 2 choice components that write to 2 user-specific columns, then add an inline list of all evaluations and filter the student ID & activity columns by the choice made in those 2 user-specific columns. ---
**Author:** ![Abdelghafour\_Benkass](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/abdelghafour_benkass/32/1694_2.png) [@Abdelghafour\_Benkass](https://community.glideapps.com/u/Abdelghafour_Benkass)\ **Post date:** [August 13, 2020, 8:02am UTC](https://community.glideapps.com/t/help-needed-people-evaluation-and-many-to-many-relationships/13892/3 "2020-08-13T08:02:32Z")
Thank you for the reply 🙂 But what if I don’t want to use choices ? From a user experience perspective, it’s very bothersome when you’re evaluating multiple students at the same time to have to switch between them every time. If there’s no other way, I’ll try it this way and see if it’s ok with the users 🙂 ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [August 13, 2020, 8:18am UTC](https://community.glideapps.com/t/help-needed-people-evaluation-and-many-to-many-relationships/13892/4 "2020-08-13T08:18:34Z")
So what’s your ideal outcome of the screen users see? ---
**Author:** ![Abdelghafour\_Benkass](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/abdelghafour_benkass/32/1694_2.png) [@Abdelghafour\_Benkass](https://community.glideapps.com/u/Abdelghafour_Benkass)\ **Post date:** [August 13, 2020, 10:44am UTC](https://community.glideapps.com/t/help-needed-people-evaluation-and-many-to-many-relationships/13892/5 "2020-08-13T10:44:47Z")
The second screen in the image in my original post : imbricated lists like this: list1 - student -\> list 2 - criteria + evaluation