Calculation to display a user managers Fullname

Discussion created by RayGerman on Apr 19, 2016
Latest reply on Apr 20, 2016 by erolst

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?