I received the fix for this problem from someone who emailed me off the
boards because my original post was closed due to being too old. I
wanted to post it here in case anyone else is having problem! Thanks
so much to Dante who helped me!!!!

MY ORIGINAL POST: May 2006

I have a weird problem. When I run certain scripts (or perform certain

finds), the found set of records includes a blank record. You cannot
enter into the record (even though I am in browse mode). I delete the
blank record and then print my report. But, then the next time I run
the report, the blank record magically reappears!

Today, I had another record start malfunctioning. I tried to duplicate

it and delete the original record, but it was acting the same way.
What would happen was that a field with a value list was marked "SOLD"
and I searched for "PAID" and this "sold" record kept showing up with
all the "paid"s. Next thing I know, the record is completely blank and

you cannot select any of the fields. So, now I have TWO of these
stupid blank records that keep reappearing in search results. Come to

think of it, the same exact problem with the "Sold" vs. "Paid" was what

created the first blank record.

I am using FM Pro 5.5 and it is a multi-user file. Any ideas? It is
driving me crazy.

HERE IS THE FIX THAT I WAS EMAILED BY DANTE:

I think I can help. I work at a small university here in California and
we were having the same problem as you are. We are running Filemaker 8.

Anyhow today me and some other dude were trying to figure this out and
we found something. Here is what we found: The problem has to do with
Indexing.

So what you need to do is turn indexing off on all of your fields that
you do finds on. For example. Id, SSN, Last name, paid, and so forth.

To do this, you have to go to define fields (FMP 5.5), select the field
that you need to do Finds on. Click Options
then go to Storage Tab and turn Indexing off then Click Okay. (Repeat
for all the other fields you do finds on)
Once you have finished. Click Done.

Now go back and repeat all the steps but instead of turning indexing
off turn it On. Do this for all fields that you want to do finds on.
Once you have finished click Done.

Now see if your problem has gone away.

Let me know.

RESOLUTION:

This fix totally worked! I just turned the indexing off on the fields
that I performed finds on in our main layout. Then, went back and
turned it back on. I deleted the blank records (they were easy to
delete, but the problem was they kept coming back), and voila..... they
never came back! What a weird glitch...... Anyway, hopefully this fix
will help other people!