I ran into a curious database problem. It looks like there are 3 identical records with the same Recnum in an embedded database file. Besides, there are two additional fields connected to unique indexes. One of these is an alphanumeric item number, ARTKOD. If that column is focused in a selection list, three identical lines are shown, but if I focus another column, only one line is shown. Also, if I loop through the file by the ARTKOD index, I get three identical records. I re-indexed, but nothing was changed. Database Explores show the same, se Recnum 474902 in the attached pictures. How can it be like this?


Click image for larger version. 

Name:	db1.png 
Views:	61 
Size:	99.7 KB 
ID:	13281Click image for larger version. 

Name:	db2.png 
Views:	59 
Size:	97.1 KB 
ID:	13282