Phantom record bug -- how do I fix it?

[Steverino]

I have a phone sheet, where each record is marked IN, OUT, NEED TO CALL, or CONNECTED. I have a button that will find and sort only the IN, OUT, and NEED TO CALL records. However, one record marked CONNECTED kept appearing after the find and sort (and only one of the records in that category, so I know that I didn't need to rewrite the script or there was a problem with the find). So, I deleted the record a number of times, but now when I sort a "phantom" record appears -- it's blank, and you can't enter the record. It goes away when you delete -- only to reappear when you do a find and sort. Why did this happen and how do I get rid of it? (Also, the file is hosted by my assistant, but when she tries to delete the record she gets the same result.)

[EddyB]

Hi,

How do you delete the "Phantom Record" if you cannot get into it?

Are you sure your Find and Sort script does not have a New Record step in it? That seems the only logical explanation if a new record is created every time you run the Find/Sort Script

Ed.

[Steverino]

I can't enter the fields in the phantom record, but I can be "on" the record and I can delete it, at least temporarily. And no, the script does not have a New Record step in it. This is clearly some kind of bug in Filemaker 5.0 v3 -- I'm curious if anybody knows how to fix/prevent it.

[SteveB]

Try recovering the file, and see if you can delete it in the recovered file.

Steve

[danjacoby]

When you say a record appears, does this record get created during the script (i.e. you start with a total of, say, 56 records, and somehow end up with 57, of which, for instance, 42 are found)?

Try doing the find manually, and if it works then open the script and close it, replacing the Find with the new one.

[Steverino]

Recovering the file worked. Thanks!