Using a list of fields in a found set as the basis for a new set
I would like my users to be able to quickly show all the "cluster" records a particular record appears in. For instance, if record 10 is used to inform records 14, 20, and 24, I would like them to be able to hit a button and have those cluster records 14, 20, and 24 displayed to them.
The idea I had was that it would take the id of the record on the Observations table, run a find for that field on the ObservationsSelfJoin table, and use the record ids on the _fkLinkedObservationID column to loop through and mark those records in a global field, and then display the relevant records on the cluster layout.
I'm not certain how to jump back and forth between the list of found records on the ObservationsSelfJoin table and the various layouts. Here is the closest I've been able to figure it out, but it's not working right:
The set field [Observations 2::__keyholder_gk; etc line is for inserting the global key variable.
Here is my database: