4 Replies Latest reply: Jul 20, 2014 5:48 PM by Janet Halliday RSS

    Creating hierarchy from simplified personnel file...

      I have a very simple personnel file which lists EMP#, EMPName, MGR1# and MGR1Name for everyone in the company. From just this data, how can I then look-up the MGR# and use it as the EMP# to gain that person's MGR# and MGRName?  I keep getting circular references or synthetic keys.  FYI, I need 4 levels of MGRs so I will need to repeat the process and change the result to MGR5# and MGR5Name.