I have a Members table in which I need to determine current members.
Current is derived from a Payments table. Each dues payment has an expiration date, and I use Max(Payments::ExpirationDate)>Get(CurrentDate) to set a CurrentCalc flag in Members.
The problem is that when I find current members for the first time, the find takes about 10 seconds when the solution is hosted remotely. I believe that this is because the current calc is unstored (because it references a related table's field). I tried to use an autoentered calculation (CurrentCalc = 1) in a number field to speed it up, but it gave incorrect results. I don't know why the calculation did not update properly.
I am in the process of updating this solution to FM12, and I'd like to get rid of annoyances like this in the update.
Do you have a suggestion to modify the solution to speed this find up?