Jim,
SEEKs should be essentially instantaneous. If yours is running slowly on 75,000 records then it is NOT SEEKing. You must match the format of the SEEK
exactly to the index. If your index says upper(fname) +lower(lname) then the data in your SEEK string must be upper(fnamevariable)+lower(lnamevariable), and they must be EXACTLY the same length as the fields.
HTH
Barbara
>Everything is running fine now although it is a bit slow there is only 75000 records and i seek off it like 7 or 8 times in this routine and it seems to take some time is that normal or can i speed it up a bit some how