Have you tried a complete rebuild of both the table and the index? I have seen situation where both a table and it's index seems to be ok, and even a pack and/or a reindex did not fix it. To rebuild the table completely, you have to copy the file twice
lcSafety=SET('SAFETY')
SET SAFETY OFF
USE myTable EXCLUSIVE
COPY TO dummy WITH CDX
USE dummy
COPY TO myTable WITH CDX
ERASE dummy.*
IF lcSafety='ON'
SET SAFETY ON
ENDIF
NB! VFP8 and VFP9 have better error checking of your tables/indexes!
>Thanks Tore, i'm happy to listen to any suggestions that can help resolve it.
>
>If it was a hardware\cabling problem why would it only ever effect one table?
>
>I have seen before where backup software or virus software can screw the indexes but because its only happend to one table i dont believe it can be that.
>
>Jon