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.