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:
This creates the following (in which I have made up students' names):
If it helps to know, each teacher and each class also have ID numbers and have created the following relationships:
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):
Class: LS2 AM
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.