> > I'm trying to set an index as the primary key. When I hit ok, it says "Uniqueness of index NAMEID is violated."
> > What am I doing here and how do I fix it?
> >
> > Aaron Hathaway--
>
>
> That error means that you already have duplicated values in that/these field/s which is/are in the KEY of your newly created index. Maybe there are some deleted records so you can PACK the table before you creating the index or you could set a filter to that index FOR NOT DELETED(). In VFP9 if SET DELETED is ON that index could be used for Rushmore optimization.
>
> -----------------
> Borislav Borissov
>
> Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
> The only thing normal about database guys is their tables.

oh gotchya, thank you :)


Aaron Hathaway--