Help

Grouping by individual fields when there are multiple linked records

1109 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Sean_Eio
4 - Data Explorer
4 - Data Explorer

Hello! I’m running a database for my private education business. A single child can be enrolled for multiple classes (detailed in a field called “Classes Enrolled into”, and I want to be able to see each individual class when I group it by this field.

Eg.
If Student X is enrolled in Grade 1 Math and Grade 1 Science, and Student Y is enrolled in just Grade 1 Math, I wish to see this when I group:

Grade 1 Math
Student X
Student Y

Grade 1 Science
Student X;

and not:
Grade 1 Math, Grade 1 Science
Student X

Grade 1 Math
Student Y

Any ideas?

Appreciate your help guys! :slightly_smiling_face:

2 Replies 2
Ivan_Carlson
7 - App Architect
7 - App Architect

Sounds like you need a join, junction or linking table between the Students table and Classes table. You could call the join table “Enrollments” and group the enrollment records by class.

Anna_Sorbian
4 - Data Explorer
4 - Data Explorer

Hey! Does any of the apps solve this issue in a quick and easy way?
It is really a burning topic for me. I would be ready to upgrade my account to have it solved by some app.