Hierarchal Portals Using ExecuteSQL
Hierarchal Portals Using ExecuteSQL
27 mars 2013 - Auteur : - Categories : Blog, English content, FileMaker, Technique

Hierarchal Portals Using ExecuteSQL

Recently, Doug West, Excelisys, published an interesting and simplified technique to manage hierarchal portals in FileMaker.

Still, it relies on a data model that makes the handling of hierarchy difficult (move, duplicate, sort) or impossible (many-to-many relationships…)

Here is an alternative based on the very same example (and the same data), using FileMaker 12 ExecuterSQL function, in combination with FileMaker recursive capability. Custom Function

Download

 

Ajouter un commentaire