March 13, 200916 yr 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
Create an account or sign in to comment