AnsweredAssumed Answered

Data value/find Corruption

Question asked by MongoTheGeek on May 8, 2009
Latest reply on May 8, 2009 by mrvodka


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.