Parent child hierarchy - from two columns

[T1969]

Micron,



Thanks for your help on this one you were correct your method did work. There was one major problem "myself". With a little help from a college at work I was able to replicate, my skill level is low at best.

Again thanks for your time to resolve.

[Micron]

So glad you got it solved. In a case like this (where it seems to get complicated) I worry that my grey matter is turning into compost because it seems I'm not grasping the complexity of it! Let's hope that as you go deeper, it continues to work.

[CJ_London]

Glad you got there, but the solution you have adopted covers 2 levels, the solution per Allen Browne goes to 4 levels - it can be extended to 5 or 6, maybe more. But you mentioned up to 20 levels. So think I haven't understood the question