Search and scroll with ODBC

I've learned most of the basics for using an ODBC database but one simple (or so I thought) task is causing me trouble. I want to search for a particular record and from there do OnMove(ID_RECORD_NEXT) or OnMove(ID_RECORD_PREV). My problem is that the only way I've seen to find a particular record is to filter the database for that record. Great, but no moving from there. Of course, I could always search for the record by doing OnMove(ID_RECORD_NEXT) through the database until I found the correct record, but what if there are 50,000 records and the one I'm search for is the last one? Very ineffecient.

So, my question is: What is a better way to find my record without filtering?

I've searched through several books and the online help, but to no avail. Thanks for any suggestions!

John Kelley

"Try not. Do, or do not. There is no try." - Yoda