>I have spent way too long on this.
>
>I have a database, 50 records, using create curson. need to index 5 fields
>
>index on field1 to field1
>this works but as I add indexes each additonal steps on the one previous.
>
>I know ther is a simple answer.
>Help tells me to use unique wich would be wonderfull if i didn't use the same number twice. (Useless)
>H E L P
>
>
>
>Thanks
what about index on field1 tag field1 additive