I know there is something else that can be done, if I think of it I will post it
>Thanks for the help, I was trying to avoid indexing on recno() but it sounds like I'll have to.
>
>
>
>>
>>The only thing I can think of might not make anything faster
>>index on recno() tag recno
>>
>>I don't know if you know but a SQL statement looks for a cdx (index tag) that will optimize the search
>>
>>hope this is a plus
>>
>>