Hello,

I'm having a problem with selecting data from a SQl server database.
My select statement returns about 25000 records. I want to show only 50 records at a time and the user can set the sort order for to any field in the recordset.
To show the first 50 records is no problem, but how am I going to show the next page (record 51 - 100) when the user sorts the records to a non unique field?

TIA