AnsweredAssumed Answered

Calculation field not working on server copy of db

Question asked by tgthibodaux on Apr 7, 2017
Latest reply on Apr 10, 2017 by philmodjunk

We have recently swithced to using FileMaker Server v15 and now have a problem with one of our calculation fields. This field is doing a on-the-fly sum of remaining objects. When accessing the db from the server it does not calculate but if I open a local copy it does. I have also noticed that if I "flip" thru the results it updates as well. So it appears that only when I do a find for a specific record it fails to update.

 

The field in question appears to be an unstored calculation field that simply a total from one db subtracted from another on a seperate db (IACUCProtocols::TOTAL IN STUDY-Records::Sum of Proto).

 

I apologize if this seems vague, I am by no means an FM genius, this is something I just inherited.

 

Any assisitance is appreciated.

Outcomes