I’m looking to create an interface that displays a list of all linked records inside one field of a specific record. I also want to list info about those linked records.
To be more tangible… this is about creating a rosters for each of 10 different classes at a small school. I have a Classes table and a Students table. It is a many-to-many relationship. Some students are enrolled in more than one class. Each class has multiple students.
I want to display each class roster separately, plus info about each student (phone number, age, etc). A teacher wants to click a button with their class name, and see only their roster plus info about each student, in a grid/list.
TIA!





