Creating hierarchy text (R1 > R1' > R1'')

[cbsteven]

Hello,

I have a table of this format:

CATEGORY_NAME

CATEGORY_ID

PARENT_CATEGORY_ID

Is there an elegant way to have a text field in each record that will show the names of it's parents, grandparents, great-grandparents, etc., all the way to the root? For example:

"RootCat > SubCat1 > Subcat2 > Subcat3"

I tried some obvious (to me) methods with selfjoins, but I couldn't get it to display more than 2 or 3 levels deep. I found an example solution that did what I want along with many other things, but I think/hope it is overkill.

Any tips would be appreciated.

[comment]

See:

http://fmforums.com/forum/showtopic.php?tid/198869/

[cbsteven]

Thank you very much. I'm not sure exactly what is different about this than what I was trying, but it works.