I would like to do something like the multi-column Finder on the Mac. I need three portals (assuming portals are the way to go). The first is Schools that I can scroll through. 2nd is the Classes offered. 3rd is the Students enrolled in the class. As I scroll through the Schools, I would like the Classes to populate accordingly. As I scroll through the Classes, I want the Students to populate accordingly.
I cannot figure out how to define my Layout, though. If my layout is based on Schools, I cannot create a portal based on it because the portal selection only lets me select related tables, not the table the layout is based on.
Thanks for any hints!
Filemaker 10, MacOS 10.6