AnsweredAssumed Answered

Restrict users access to records

Question asked by Karnel on Nov 13, 2008
Latest reply on Nov 14, 2008 by Karnel


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>?