Lists for display or for printing?
For the former, a portal based the Enrolment table would be an easy solution; for the latter, create a list layout based on the Enrolment table.
How are the enrolment records created at the moment, i.e how do you add students to a class?
Thank you for your reply.
It is for printing. The organization wants to be able to print a class list for each instructor and provide it to him/her at the start of the 7 week course.
As for your second question, the following screen puts the students into the course:
So, the student is chosen, and the class (which is attached to the teacher when the class is set up) is selected through drop-down menus. A session is chosen at the right side based upon the date (i.e. current session is session 12.5 and goes for seven weeks starting May 5). Did I understand your question correctly?
Thank you of your time.
Sorry, I should have paid more attention; you already described this in your initial post.
As mentioned, a list layout based on the enrolment table is the best way to create a print layout.
From a Class layout, you could use this script:
Go to Related Record [ from: Enrolment ( Enrolment ) ; layout: ClassList_print ; matching only ]
Sort Records [ Enrolment::session ascending ]
assuming a newly created layout ClassList_print, based on Enrolment.
This will find all the Enrolment records (.i.e. Students) for the class. Display the desired fields from the related Class record in the header, and the fields from Student in the body.
If you want to see the class broken down by session, add a sub-summary part sorted by session, put in the session field, and sort by session.
Note also the Layout Setup option to print several columns, which may be appropriate for a directory-style printout.