You are doing the native FileMaker - find? No custom menues with scripted find?
Local or via FM Server?
What says the log when You repair (a copy!) the file?
Other fields are working in order when You perform a find?
Can You create a clone and import the data? Does that solve?
What version? There are/were some issues when using FMS with unstored calc-fields ('Find') -> restarting the server helped. Not sure, when/if this issue was solved...
File is on FMServer, but I took it off FMServer to rebuild the indexes and online or offline it does the same.
The log file when I do a repair shows no errors or warnings at all!
I might create a clone next, perhaps a compacted clone.
This is all up to date FMS15 on indexed fields.
it's certainly strange behavior. Is it possible that the field contains a list, and that 9655 is hidden? That is, you might have a field that shows a single line, while it actually contains a list, like:
Hi problem found. Sorry guys my error.
The relationship between these two tables is a hardware serial number. The hardware was swapped from an old deactivated unit to a newly activated unit. So the serial also swapped from unit to unit, my relationship didn't also exclude deactivated units so that is why the wrong unit was being found.
The problem is now fixed!
for anybody following, Carl said he tested ==9655. That precludes my suggestion of 9655 being hidden in a list. My bad.
If I read this right, this is a common mistake reported here in the forum that comes when you search for data in a field from a related table. The find finds a record in the layout's table that has more than one related table. If any of the related records have a value that matches the criterion, the record is found even though the single field does not display that value due to not being in a portal that can list multiple related records. (The field shows the first related record, but the find matches on any of the related records...)