> >
> >
> > 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--

Aaron,

If Borislav's reply was of value to you, perhaps you could take the time to give him a rating. Just click on his reply and then click the "rate this" link at the bottom of the message header. When you give a rating, not only do you show appreciation, you also inform other members (who may be facing the same sort of problem) that Borislav's reply was of value to you and therefore could be of value to them.

Ken
You shall know the truth - and the truth shall set you free. (John 8:33)