Help creating class lists

Discussion created by LMac on May 1, 2016
Latest reply on May 1, 2016 by erolst



I am an extremely low-level FileMaker user but with the help of this community, have created a fairly basic data base that can be used to capture details about students, then add them to classes that are created in each session.


To do this, my database contains three tables: student details, class creation and student enrollment which adds the students and classes together. Once a student and a class are added to the database, the user can add the student into a class:

Screen Shot 2016-05-01 at 11.25.39 AM.png

This creates the following (in which I have made up students' names):

Screen Shot 2016-05-01 at 11.37.05 AM.png

If it helps to know, each teacher and each class also have ID numbers and have created the following relationships:

Screen Shot 2016-05-01 at 11.47.15 AM.png

I would like to create a list of students who enroll in each instructor's class by session and class name. For example (using the details above):



Instructor: MC

Class: LS2 AM

Session: 12.5



Peter Cetera Phone number(s)

Anne Frank Phone number(s)


I appreciate any help the community may provide. As I mentioned, I am pretty new at this, so please don't be concerned about giving me too much information or insulting my intelligence. Neither are at risk


Thank you so much for your time.