Anil,

Have a look at message #583183 and see if that applies.

It basically says that adoption of 2 fake fields, one type I and one C(10) as first fields in the table alleviates the problem described there, which may or may not be similar to yours.

good luck

Mumbai in the U.S.???

>I am Using Double Data type in Primary key and same reference key is available in child table. In some table it is primary key and in some table it is candidate key, but some time it corrupts index files and in dbf it stores duplicate keys (which it shouldn't be, since it is Primary key or Candidate key). So Because of Index corruption it stores duplicate values in dbf table or because of duplicate values in dbf it corrupts index? or any other problem like virus which corrupts dbf or cdx file? any body has idea?
>
>Anil Lakhani