Take a look at the sample files posted by Ernest Koe at (http://proofgroup.com/blog/2011/aug/devcon_2011_recap#attachments)
The Accordion Demo is a great example of what you are looking for, plus about 20 other things you should be thinking about. He encourages people to take ideas from these files, and even has started a design-centered site for great interface design ideas that are portable to your FileMaker solutions. (http://fmpatterns.com/)
Within the Accordion Demo, take a close look at the relationships graph and the function definitions for node::children_idList which uses the List() function along with the relationships to produce the kind of information you are looking for. It may take some adjustments if you want the text to appear as you typed "Building 2 > Fourth Floor > Room 1 > Bar Area", but after seeing the file, you might want to use more of it than what you have built already.
-- Drew Tenenholz
I believe this should work:
Substitute ( List ( Parent::cBreadcrumb ; Name ) ; ¶ ; " > " )
Hi Michael & Drew,
Thanks very much for your help on this. I had a look around the Accordian file but the breadcrumb calculation was quick and perfect thanks.
I'm glad the simple calculation suffices. It is very similar to the one used in the accordion file, except that there is some text manipulation to make it look pretty.
The accordion example does many things including a nice set of portal key value manipulation steps to give a very pleasing and intuitive 'drill-down' interface for your hierarchical tree of values.
With a little manipulation, you can set up the script triggered when clicking an item with no descendents to display some very specific information like another portal of all reservations for a room, limited to only a certain date range. It is sort of springboard for making an interface that lets your users zip through their work.