2 Replies Latest reply on Dec 19, 2016 11:49 AM by skywillmott

    Limit certain records to certain logged in users?

    octane352

      Hello.

       

      Trying to figure out how to do the following.

       

      I have 3 different users setup in the system. These users need to only see certain work order, store, etc  that fall into their regions.

       

      So I need...

       

      user one to only be able to see work order records for ONLY Region (Ontario)

      user two to only be able to see work order records for ONLY Regions (BC, AB, SK, MB)

      user three to only be able to see work order records for ONLY Region (Quebec)

       

      Admin user would see all regions.

       

      Whats the easiest way to set this up with FileMaker?

       

      I have separate tables for all stores, employees, companies, work orders, etc.

       

      Thanks for any help.