AnsweredAssumed Answered

Subset layout views of table records (- not using a portal)

Question asked by onecb on Feb 23, 2018
Latest reply on Feb 27, 2018 by philmodjunk

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.