Find freezes on only certain criteria

[vanderark1]

Strange FIND problem in FM 5.5:

I have a script which searches based on user select of a foreign key file (they are all unique)which is the employee number.

If nothing is found, it returns a custom message. If any are found, it switches layouts and shows those records.

Works perfect, except when I search for one of two people. For these two people only (and I checked it with every person), if they have records to find, it hangs up. There is no loop in the script, but it acts like it. I need to abort to bring it back. It returns no records.

If these two have no records, it returns the custom message.

I can go to the layout it ultimately ends up on, and search for one of these two there, and it returns their records fine. But the script doesn't like these two people (or their fk_employee_number).

I have searched everything on the db to see what these two have in common, but am coming up empty.

Any ideas?

[Charles Delfs]

something in the record is corrupted. I have had this with some container fields from time to time. delete the record and recreate it from scratch by re entering all the data, don't just so a duplicate.

Charles