Getting infinite loop from On Layout Load Script Trigger
The script shown below is creating an infinite loop.
The script runs whenever a sub summary layout named "Ranking of Issues" is loaded. This layout is based on a child table named "Issues". Some values in the Ranking of Issues are calculated based on a related parent table, Surveys.
To get the value from the parent, I *think* I need to temporarily open a layout in the parent, perform a find, set a variable and then return to the layout based on the child.
When I return to the child, the script trigger activates again. Is there a way I can get the info from Table 1 without causing this loop?
FYI: I go to Table 1 (Parent) to find all of the records in Table 1 that have at least one related record in child Table 2. This number is stored in a $$ variable that is used in Layout 2.