We have an odd problem plaguing one of our databases. Out of the blue over 200 records have cleared themselves leaving empty fields in every field. However, if you do a search for a name whose record was cleared it finds it and takes you to the empty record.

In FileMaker 8.5 all the fields are empty but in FM 9.0 they all have a question mark in them.

Any ideas on what is going on here?

As a side note, I ran Recover on the file and it deleted all those records whose data went missing. That was not the outcome I was hoping for.

Any advice is greatly appreciated.