Force field re-index
Is there a way to force FMP or FMSA to re-index a field?
We have FMSA 9 and FMP 10 clients. (Currently upgrading to 11 but need to but a new server machine for the server side).
I have a relationship that shows me a collection of values from within the lats year so I can produce an average value for with in the last 12 months.
Unfortunately to do this I had to base the relationship on two fields, one of which was a calculation (at least I couldn't think of another way). Thus the calculation must be indexed.
Sadly the calculation value changes every day and so before long the returned records go funny - once the index is out of date.
Is there a smarter way to do this or can I schedule a script to force a re-index once a day?