Brecht

I will look into this. Thank you for your help and time!

Yes, that is correct!! I tried for a couple of hours but I don't find how to do it...

One more question: I am on the "Schools" table and I create 3 schools (so I have 3 records). Then I create Courses, SchoolYear, Departments, etc... All on the layout based on the "Schools" table. So far, so good. Next step is to create classes. I also do this on the "Schools" table with a portal to "Classes". That works fine but I want to have a dropdown list with the SchoolYears so I can select the current SchoolYear. Ok, I only need one SchoolYear per year and that is ok but when it is june, a teacher is planning his Classes for the next SchoolYear, so he needs to have the possibility to make his provisional Classes for the next year. And when it is september (new SchoolYear) he wants to start with the new Classes. How do I accomplish this?

@comment Thank you for your advice!! I have added the table school and am even starting my solution from that table now. Almost everything works fine. I am able to create schools, courses, students, ... I still have some issues but I am learning, trial, error...

@comment: It is not the intention to share data with multiple teachers. The application is separate from a school and is for personal use only. The user wants to keep track of the data of his students, wants to mail homework to his students, wants to see, modify, sort and print class lists. In attachment you will find what I have already made. I am quite satisfied with the functionality but the problem is that I see all the students in one list and all the value lists of the different schools together and I want to see them per school. All this is built from the student table. Perhaps your final sentences are the direction that I should go out. But I do not understand how I can eliminate the value lists because classes have to be made of a number of parameters (course, weekday, hour) before students can enroll in it. And those parameters are value lists, not? Students2.fmp12

Thanks for your reply! Yes, the steps for the user are: 1. Add/Create school 2. Create Departments: Do I need a new table for this? 3. Enter data for the value lists (courses, weekdays, hours) 3. Create Classes 4. Create Students 5. Assign Students to Classes In my first solution I started from the students table. Knowing the choice for the school is captured in a global field, can I still start from the students table? At this moment I do not know how to set up this global field as a match field, same for filtering the value lists. Could you give me a 'tip'?

I have been working with Filemaker for 1 month and want to set up a sort of 'agenda' for teachers. I had already made something that worked well but then came to the conclusion that my base was not okay so I can start again ... It's like this: A teacher teaches in multiple schools, each school has several departments. When the teacher opens the app (or logs in), he wants to assign students to one of his schools and then assign lessons to that student. The teaching moments differ from school to school. It is not the intention that he sees the lesson moments of school B when he adds and assigns students in School A. I mean by this: If school A has following lessons: "Monday 16h-17h mathematics" and "Monday 17h-18h gymnastics" than I do not want to see these possibilities in school B if they do not exist there. I would work with either predefined teaching moments (teacher makes these first) or through choice lists in lessons, weekdays, courses ... Perhaps predefined will be the best solution? So I should actually have a choice when opening the app to which school environment the teacher wants to go. But he also wants to be able to switch between the schools ... Below you see the ERD that I made. I'm not sure how to proceed now: Do I need 2 layouts where I filter by school? Can I filter these lessons and the students? And which table will that layout be best based on? Thanks in advance if someone has time to check this and to help me further. Brecht