AnsweredAssumed Answered

Calculate hierarchy in a self-related table

Question asked by jorber on Sep 21, 2016
Latest reply on Sep 21, 2016 by 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

 

 

Outcomes