octane352

Limit certain records to certain logged in users?

Discussion created by octane352 on Dec 19, 2016
Latest reply on Dec 19, 2016 by skywillmott

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.

Outcomes