I'm trying to create a process that will allow someone to view all unassigned records, but only 10 at a time. I'm creating an interface to someone else's SQL Server system. This interface will get ported to the web.

There's no index on the table, so I can't retrieve records based on a key.

Does setting the Fetch to 10 really work to limit the bandwidth used. I've thought about doing a fetch of 10, populating a list box with the results. There would be a "Next" button that would skip 10 and repopulate the list box.

Any and all advice appreciated.

PF