Strange 'ghost' record issue

[montlewis]

Hi,

I have a 8.5v1 database that has this weird issue that I've never seen before. In one of the tables, when I do a search on a particular ID, I always get a blank record as one of the records in the search results. If I delete that record, do the search again, it reappears. If I view all records in the table, there are no blank records.

It's messing up my scripting and I'm at a loss to figure out how to handle it. Has anyone seen this type of behavior before?

Thank for your help,

Monty Lewis

[Søren Dyhr]

Is it a shared solution?

http://www.fmforums.com/forum/showtopic.php?tid/182861/post/233105/hl/sharing/

--sd

[Zero Tolerence]

We've had this issue, and other worse ones here. Best bet for you. Export all your data (Just in case) Then Recover the file.

[Inky Phil]

You might also try re-indexing the id field (go in,turn it off, come out, go back in and turn it on again). That might just do it

Phil

[montlewis]

Phil!

That did it! Thanks for the help!

Monty