I am creating an app to handle employee vacation. Right now I have 2 roles: Employee and Manager. I also have two tables: Employee and Manager. Everyone is an Employee and that is where you track your personal vacation days. When you click on a Manager, you can see all of their direct employees and they collected vacation schedules.
When you log in as an employee you only see your vacation information. That is easy. When you log in as a manager, you need to see your personal information and the information of all of your direct reports. Because the custom rule is an "And function", I can't set it up so that you can see things when the "Manager User" equals current user and when "Employee user" equals current user because that returns 0 results since no one is their own manager. I can make it to just look at people for whom you are the manager, but then you can't see yourself. I can also set it so there is a formula field that returns a certain value if the employee is managed by you or is you, but then the manager's manager won't be able to see that record. Because our org chart is stacked several people deep, I don't want to have to create a new table for each level in the company to look down.