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

Is it a shared solution?

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

--sd

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.

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

Phil!

That did it! Thanks for the help!

Monty