1 Reply Latest reply on Sep 27, 2018 7:56 PM by swaroop.gantela

    How can I get information from one record based on a field in another record?

    Jim Willsey

      I'm dealing with employee demographics, and one of the fields is their manager's Employee ID. Each employee's own Employee ID is also included in the data. For example:

       

      Employee IDEmployee Name
      Manager's ID
      123JohnABC
      ABCJane789
      789BillXYZ

       

      How would I create a field that would give me, for example, their manager's name? So if my report listed John's info, how could I have it include that his manager's name is Jane?