Hello all, I’m working through the parent-child relationships of a self-linked table. I need to build a hierarchy or path which traverses a multi-level hierarchy using a “child” relationship. Some other solutions in these forums are focused on a “parent” relationship column, such as the excellent solution by @Justin_Barrett here:
Using the above solution as an example, I would like to build the following hierarchy:
I’m open to other feedback on how construct this, even if it isn’t a scripting solution. I’ve just used the above example as a starting point.
I’m also aware of the parent vs child tradeoffs of self-linking tables. I’ve gone through multiple iterations of this project already, trying both approaches.
Thanks for the help!
Solved! Go to Solution.
Welcome to the community, @maqjara! :grinning_face_with_big_eyes: Thanks for the nod! I can definitely see the benefits of working the tree from the other end, and I don’t think that it would take much to modify the script that I shared in the other thread. I’m tight on time at the moment, so it might take me a few days, but I’ll see what I can do.
It took a little longer than I thought to get around to the update, but it’s done. I just added it as an option to the original script instead of making a whole new script. The link in the original thread still works, but I’ll add it here for those who might find this thread first.