AnsweredAssumed Answered

Force field re-index

Question asked by Bucko on Apr 12, 2010
Latest reply on Apr 12, 2010 by comment_1

Title

Force field re-index

Post

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?

 

Thanks

Outcomes