In my user table, I have email address, name, and role. Roles are admin, manager, user.
I’d like to setup something, when any user logs in, it should show them their respective screen. User will need to see Screen B, whereas admin and manager will need to see screen A.
Thereafter, I want to implement something for the user role, so that they can only see their data - especially the user role, because admin and manager should see everything - show all data where empCode in BEN table and in EMP table equals their empCode.
In the Users table, I also added their empCode, with relation and lookup.
Something I find confusing: If I edit Screen B where I drill down into a specific row Fields, and change the Fields I want to see, the same change will happen on Screen A. I was under the impression if I edit a specific screen, it will only apply to that specific screen and not other screens that use the same data.