Current user
I have an app to schedule vacation requests. The user logging in should only be able to see vacation requests of his own or his subordinates ( so He can approve requests) How can I restrict the vie...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendCan you prove a bit more detail on the Tables and their relationships? Do you have a table of Employees and a Table of Supervisors? Or just a table of employees? What is the many to many between?
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
- I have one table called corporate directory; it lists the employees and their supervisors. I created a many to many within corporate directory to pull supervisor data see below
------------------------------
Rhonda Parriet
------------------------------
------------------------------
Rhonda Parriet
------------------------------- MarkShnier__YouThat looks like a good app design.
You can lookup the Supervisor userid down to the vacation request. Then set the Custom permissions for View and Edit where
any
[Employee user] is the current user
[Supervisor userid] is the current user
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
