1 Reply Latest reply on May 27, 2015 8:16 AM by philmodjunk

    Custom privilege set for each agency

    KylerPhilips

      Title

      Custom privilege set for each agency

      Post

      Hello

      How can I create a custom privilege set for each agency I have - I want it to be so that Agency 1 can only see related records from tables Clients, Requests etc.. where the Request has _pkAgencyId = 1 if that makes sense? 

      Thanks

        • 1. Re: Custom privilege set for each agency
          philmodjunk

          Seems like they can all have the same privilege set, but different accounts.

          A script that runs when the file is first opened, can use Get ( AccountName ) to look up the associated agency ID. A lock expression can then use that data in a "lock expression" to limit the user's access to only certain records.

          See "Editing record access privileges" in FileMaker Help and check out this particular sub section: "Entering a formula for limiting access on a record-by-record basis" for a description of how to set this up.