I'm using FMPro 16 Adv
I've used it for about 9 months and already have an implementation in use.
I have a table of children (school DB), table of Parents/Guardians and a Table of Staff where I'd like to display to the user a found / subset of records only in a layout - mostly by "Status" - e.g On Hold, Active, On Waiting List, Archived etc.
I currently use script triggers on Layout enter, but the found set is often reset when the user performs actions - (such as a quick search I offer the user on the layouts).
Can anyone advise if it is possible to base a layout on a subset of records on a semi permanent basis e.g by using a self join relationship ?
My layouts currently use other portals and Tabs to display related data.