Infinite Hierarchies - Creating a Folder Tree

Folder Trees, as they are commonly known in an interface designer's vocabulary, are one of the more complex techniques to add to a database. You need to have a solid understanding of the Parent > Child relationship between records and understand how one series of inter-related records is different from any other series - all within one table. Oh, and there's that new aspect of FileMaker Pro 7 that allows for recursion within calculations.

This video presents a very powerful technique which teaches you how to create and use an infinite hierarchy of records - well, maybe not infinitely, but a whole bunch!

AttachmentSize
InfiniteHierarchies.zip212.09 KB

Comments

Hi Matt,

I wonder how can I move a project inside another one. I tried in different ways, always without any luck. It's useless to change the PID value...

Any suggestion?

Thanks,

Paolo

Posted by: paolod
Thu, 09/02/2010 - 8:42am

If you have time, I would love to see you revisit this topic to see how you might approach it differently with the latest version of FM Pro. I've been searching for examples for an infinite nested record type of structure, and how to display it. This seems intriguing.

Dave17

Posted by: Dave17
Mon, 11/06/2023 - 10:44am