I am creating a user table for our organization
Each user get a primary key and a first and last name field.
I have a calculation that concatenates the first and last name so its easier to read
Calculation for fullName = FirstName & " " & LastName
Now a user can be a manager, so I created a field User_Manager_ID which I would like to reference the PK_User key.
I would like to display the first and last name of the users manager via a calculation field but I am not sure how to create a calculation to pull the values.
In the table shown below first 3 users, have a manager with the Primary Key of 10 which would be Susan Williams.
What would the calculation be to show the Full Name Susan Williams in a manager field of my table?
Hopefully this makes sense?