Hi @alfroc , it looks like you deleted your post where you said you figured it out. Does this mean that you still need help?
I wrote something a while ago that shows the hierarchy and path of a parent-child relation table that may be is similar to your issue:
You can see the results in the thread here:
2 Likes