I’ve been looking for a solution, and although I have found a few examples that are close, I have not found exactly my use case.
App will be shared with 500+ users, all at different store locations. Have one centrally manged table that will load job numbers that the locations will need to review. The data is dependent on store number, and I would like to use a table to map all appropriate users from that store to their data only.
Like the other user settings, I would like Jon, Jill and Jeff to all see the data from Store 1, and Steve and Larry to only see data from Store 2. They all have the same level of read/write permissions. What I want to be able to do, is if Jon transfers to Store 2, to simply update a table with his new location and the data that he sees when logging in would be correct (Store 2).
I know I could have them manually select their store under user settings, but for security I do not want the users to be able to jump between stores. Thus the need for central management.
How would I accomplish this?