Calculation Should Be Blank But Queries As Though It Has Value
I make a field that calculates integrity problems with the record. Then, I search for any records that have something in the error field. All the records that have data in the email field come up as having an error, though there is no text in the error calculation field when displayerd.
I've run into this problem before and can't quite identify what is going on.
It is of type text, unstored, self-references, no repitititions. I am using FMP9
Once again, my field "Error" is a case statement, the last field is "", when i do a find with * in this field, it finds all records that have text in a particular text field, but when I examine that calc field there is nothing in there. So why is the find behaving as though there is text in this field when there isn't anything in the results.
Thanks for any help!