Grouping by individual fields when there are multiple linked records

[Sean_Eio]

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:

[Ivan_Carlson]

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]

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.