Disappearing records when sorting

[dbanalyst]

I've got a table with about 153,000 records. One of the fields is "Header_ID". I'm looking for Header_ID 3118. So, if I do a find, it locates it for me...and that's fine. However, if I then sort on that field, the FIND function cannot find it, nor can I find it by scrolling down. Not only that, but then, there are only about 123,000 records. I'm totally lost..........

[mshmyob]

Show us your code for the FIND method.

Is your Header_ID a Number or Text field. If a Text field do you use ' anytime?

You could also try compacting and repairing your database to see if it is corrupted.

I've got a table with about 153,000 records. One of the fields is "Header_ID". I'm looking for Header_ID 3118. So, if I do a find, it locates it for me...and that's fine. However, if I then sort on that field, the FIND function cannot find it, nor can I find it by scrolling down. Not only that, but then, there are only about 123,000 records. I'm totally lost..........

[dbanalyst]

The first thing I tried was compact/repair. (Btw, the Header_ID is a long int.)
I'm thinking it was a corrupt record. Scrapped the table and reimported from sql table and is fine now. (That was the strangest thing) Thanks anyway