Unable to restrict access to filtered out records
I have no problem getting FileMaker Pro to filter the records based upon the Privilege set that a user has on their account upon login. However, I would like to restrict the user from seeing all filtered out records and can't seem to find a way to do this.
At present, all they have to do is select "Show All" and if I hide the Status Bar they can bring it back from the menu.
What I want is a user to log in and ONLY see records that are within their department, which corresponds to their Privilege Set.
If I can't do it in FileMaker I know I can do it in a database and make a ODBC connection, but I would prefer not to.
Any assistance would be greatly appreciated.