AnsweredAssumed Answered

Display multiple hierarchy levels of active record

Question asked by MrB on Mar 3, 2016
Latest reply on Mar 10, 2016 by MrB

Hi everyone,


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 ??