1 Reply Latest reply on May 8, 2009 12:27 PM by mrvodka

    Data value/find Corruption



      Data value/find Corruption

      Description of the issue

      I have a number field that I use for relationships.  The field holds either 1 or 0 (Arrived at through a laborious calculation) I recently had a problem in my database where while the records were being updated (using replace values) but when I did a find it found the old values.  Fields that had changed from a 1 to a 0 were being found as 1. I fixed the problem by redefining the field as a calculation and then defining it back as a number. FileMaker Server 9 viewed from 9 and 10.