Table 1 is an organization table. The two primary fields in the table is the employee name and employee email address. The table is related to itself so that employees report to employees who report to employees.
Table 2 is a project management table. The organization table is linked to the project management table whereby the application owner uses the organization table employee name field as a drop down field.
When the table user selects an application owner (employee name) it will display the name of the manager and the name of the manager's manager. Keeping in mind that every employee record has an email, what I'm trying to do is identify the email address associated with the name in the manager's manager field. I can then use a ToUser formula to get the user value associated with the email address. So, how do I write a formula to get the email address of the user in the manager's manager field?