Is for example child4 truly a child of child3? It is my unterstanding that is the case.

Thanks for the reply. It is exactly what i needed.

sorry. I didn't provide much of an explanation. I'm trying to write a proc that returns the top level parent record for any child record selected. Is there a way...