Hierarchal Portals Using ExecuteSQL
Hierarchal Portals Using ExecuteSQL
27 March 2013 - Author : - Categories : Uncategorized

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

 

Prev / Next Post

Add comment

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.