"No records match this find criteria" in error

[abailey3]

Every now and then, for seemingly no rhyme or reason, a script that relies on searching the contents of a field will start to fail with the message "No records match this find criteria." The hang up is, it will not find records even if there are records that match the search criteria. You can look at a table full of fields filled with 1's, but if you search for 1, it will say it cannot find records.

Currently, I have this happening on a field based on a self-relationship calculation. The field in question is defined as Count ( selfTable::ID Field ) and the ID Field it relates back to is a simple text field with indexing turned on.

So far, I've tried un-indexing and re-indexing the ID Field (a suggestion I had found through a Google search previously), deleting the self-relationship completely and creating a fresh one, and even deleting the relationship AND both fields (the calc and the ID Field) and re-creating them, all to no avail.

Anyone ever experienced? Is there a solution I'm overlooking?

[rt916]

I am having the same issue on FMP 11, did you ever figure out what was causing this?