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