Restrict users access to records
I need to setup user's access to my database based on which school they are in and only be able to access the records for their school. I have a field that identifies which school the record belongs to. I have been able to accomplish this by setting up a custom privilege set and have that field to = the school using a calculation. This works and that user can only see their records, but they also have all of the other records come up with <No Access> in all the fields. I'm wanting the user to only have their own records. Is there a way to have FM not show all of the records with <No Access>?