4 Replies Latest reply on Jun 3, 2011 2:12 PM by philmodjunk

    Unable to restrict access to filtered out records

    JamesGore

      Title

      Unable to restrict access to filtered out records

      Post

      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.