8 Replies Latest reply on Sep 21, 2016 11:26 PM by jorber

    Calculate hierarchy in a self-related table

    jorber

      Hi

      I have a self-related table in FileMaker called Store used for keeping track of stored objects as described below. I have tried, but failed, to create a dynamic calculation field, Hierarchy, that shows all parent positions for each object in the table and are updated when  Name is changed. Does anyone have a description how to solv this?

       

            

      __kf_StroreID_ParentStore_fkNameHierarchy
      100House 1Hoiuse 1
      2010Room 1Hoiuse 1 / Room 1
      3020Cabinet 1Hoiuse 1 / Room 1 / Cabinet 1
      4030Shelf 1Hoiuse 1 / Room 1 / Cabinet 1 / Shelf 1
      5030Shelf 2Hoiuse 1 / Room 1 / Cabinet 1 / Shelf 2
      10140Item 1Hoiuse 1 / Room 1 / Cabinet 1 / Shelf 1 / Item 1
      10240Item 2Hoiuse 1 / Room 1 / Cabinet 1 / Shelf 1 / Item 2
      10340Item 3Hoiuse 1 / Room 1 / Cabinet 1 / Shelf 1 / Item 3
      20150Item 21Hoiuse 1 / Room 1 / Cabinet 1 / Shelf 2 / Item 21
      20250Item 22Hoiuse 1 / Room 1 / Cabinet 1 / Shelf 2 / Item 22