5 Replies Latest reply on Apr 10, 2017 7:02 AM by philmodjunk

    Calculation field not working on server copy of db

    tgthibodaux

      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.