Creating hierarchy from simplified personnel file...

[#1]

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.

[#2]

Possible to attach your sample file?

[MarcoWedel]

There is a hierarchy prefix for load statements that you could use.

Regards

Marco

[MarcoWedel]

See also:

Using lookup

Regards

Marco

[#5]

@MarcoWedel The concept you post about is amazing, but I've spent my entire Sunday attempting to modify this code to work and it just doesn't sing.  I do not get errors but I do get synthetic keys for employee and manager, and I can't seem to get a full 4 levels of management

Also, I already have my own employeeID and I can understand where AutoNumber come into play, but I cannot get my employeeIDs to be allowed into the table.

Yea, I'm new, and, I have a headache   Here's hoping you can help tweak it!

I've included in the attached file are the following tabs:

Results: What I am expecting to come close to

PersonnelFile: Limited names in current format to complete 2 samples of 4 and 5 level management

TableView: just that, a pic of my tables

ScriptExport: just that, an export of my current script