Let me explain how the app works. The app will have about 500 users. The users are in different locations throughout the country and will create records called arbitrations. The arbitrations will be reviewed by a team and either approved or denied. If they are approved, a section in the table will be adjusted and now another Station will be charged and they will need visibility to those records to see why the arbitration was adjusted.
I am trying not to create 100 home pages (100 locations) and 100 roles (1 role for each location and each location will have multiple users). Each home page has the same 5 reports.
I created the new filed Current User and have User() in the formula. This works great. I can't get the second part that you said to work. The second table with the users has the Employee Number as the key field. I can create a new table like you said for user access and create just two fields: Userid (User) and Location (Text). The Userid field is blank if I do an upload so I can't set it as a key field. How can I get the Userid to populate or will I have to select them all manually?
I apologize, but this is new to me. I am trying to save some work and a nightmare in maintaining so many roles/home pages/reports.