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