I've been trying for a couple of days now to set up a database as a test that will allow teachers from different schools to access records only for students from their school.
I need each teacher to login and be able to create classes and add students to those classes.
As admin I will assign school names and account names.
Next time they log in they should only be able to select their own classes form a dropdown and go to those classes.
I have set up 3 tables Students - Classes - Schools with each school able to have many classes and each class able to have many students.
I've used privilege sets but it greys out the new record option even though I have selected the ability to create records. I'm missing something and maybe it's very complex but any help would be appreciated.