How to create a composite Status in parent for every record in child table?
I have a parent table called Task List, with each individually named task being a record in a child table called Task - these display in a portal in parent layout
Each Task has its own status field (OK, NOT OK, or OVERDUE) that refreshes as task occurances are recorded or time runs out.
Is there a function that can evaluate this status field for every Task on any given Task List, such that if every Task is OK, the Task List status field displays "COMPLETE", but if any individual Task status is either NOT OK or OVERDUE, the Task List status displays "INCOMPLETE"?
Part of the challenge is that I don't know yet how many tasks will appear on any given list, nor how many lists there will be...
ValueCount ( List ( Tasks::Status ) ) = FIlterValues ( List ( Tasks::Status ) ; "OK" )
will return true only if the value of Status in the related Tasks table is "OK" for each and every related record.
There are also ways to do this with ExecuteSQL.