> > 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 Chris, Do you mean that you want one index containing the 5 fields then concatenate the fiedls: index on fld1+fld2+fld3+fld4+fld5 tag fld Careful: you will have to convert non character type fields here. Otherwise from what you described, you did create the 5 indexes. To activate them use SET ORDER TO. HTH, Marc