Self-join for menu items?

[El_Pablo]

Hi,

How do you guys would manage a menu in Filemaker (or a forum categories could have the same complexity)?

Each menu item can have some child menu item or not. If there's no child, then there's a link to a layout.

Here is the structure:

menuItem (pkMenuItemID, fkParentMenuID, description, gotoLayoutName, uiParentDescription, ...)

So as you can see, there's a self join.

In menuItemChild context :

uiParentDescription = if (fkParentID; menuItem::description; "")

I would like to create a breadcrumb effect to show the parent menuItem, but I only managed to create a single parent breadcrumb, no grand-parent.

Thanx for any help