RayGerman

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

 

Users.png

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?

 

Thanks,

Ray

Outcomes