Just a thought on how I can speed up some calculations when going to a related layout...
On Layout2 there are a large number of fields that are summary fields of numerous calculation fields within Layout2's table (Table 2).
Layout 1 displays summary fields from Table 2. Layout 1 is very slow responding because there are many many calculations in Table 2 that must be re-calculated.
I'm considering making a new table (Table 3) where I write the values of the summary fields from Table 2 (via script) upon exit of Layout 2. I would make those values as "stored" in Table 3.
Layout 1 would display the stored values from Table 3 instead of forcing all the calculations from unstored values in Table 2.
Would this result in a speed increase when opening Layout 1?