I've been searching on this forum but been unable to find an answer.
I have a database with now 2 tables. A data table with records of topics to which I add detail info with various fields, and one hierarchy table which contains the parent hierarchy levels of the topics. I've made a self-join of this table.
I have a layout of the data table with info about the topic, related via the hierarchyID I can see what the name is of the next parent hierarchy level, but I want to see all the parent levels. How can I accomplish this ?
It is possible to make multiple self joints for each level needed, that does work, but I don't think it is the way to go as I have seen people only using one self join to accomplish this, but never was explained how.
Just to be clear. In the layout of the data table, I just want to show the hierarchy levels connected to that topic on a line like: level 1 > level 2 > level 3 > current topic.
Like breadcrumbs on a website actually.
I hope someone could help me on the way, I guess I would need some global calculation fields ??