Fabio, thanks for the reply. It doesn't catch it for me, I should say that the field I'm indexing as a primary key DOES have duplicates in the test. Thanks,

jfh

>I try and VFP Catch it correctly.
>
>

>* i try this with fine result
>ALTER TABLE myTable2 add id_MyTable I
>ALTER TABLE myTable2 ADD PRIMARY KEY id_MyTable TAG id_MyTable
>

>
>Fabio