Hi, Steven.
>One problem is navigation on my display form. If I don't pull the whole set how do I go to the next record or previous record? Although I may have this resolved. I am pulling five records plus/minus in my spt. this seems to take no more time that pulling one record and I have what I need I think.
I don't think that a previous-next navigation makes much sense over a 67K records table (indeed, I don't like this kind of navigation in any circumstance, but this could be something of a personal taste).
Anyway, you always can workaround this. Instead of pulling all the records and move with skip +/- 1, just select the next record following the one you need, like:
select * from Customers ;
where CustName > lcCurrentCustomerName ;
order by CustName ;
top 1
Of course you have to make it a bit smarter to avoid duplicated descriptions, etc, but I think you have the general idea.
Another approach (the one I prefer) is to ask for some filter criteria before getting the records, and I wouldn't let the user select "EVERYTHING" under any circumstance.
Hope this helps,