Kelly,
You can limit the records retrieved with the syntax:
DbDataAdapter.Fill Method (DataSet, StartRecord, MaxRecords, srcTableName)
By changing the StartRecord parameter, the user can work their way thru the data. I've got a generic screen that gives the users two data fields (name, street, etc.) and criteria (less than, before,etc.) The results come up in a grid on the lower half of the screen, and when they dblclick on a row, it's moved to the editing screen. On the grid they dblclick on, the primary key is always in the leftmost column, so it's easy to retrieve the right row.
So basically, decide what fields you're searching on, what the criteria are, and then generate your sql stmt from that after they click on find, fill the grid, and then move it to the data entry screen after they dblclick on it.
Hope this helps.
Ron Hodge
Sebrex Systems, Inc.
Atlanta, GA