One suggestion I want to add is to use the Primary Key for "searching".
We can also use non-numeric values for the code instead of Id or rowid.
I think the OP question is how to "search" and "read" any row he wants.
Whether he has started to "touch" the table, selecting any row, adding or deleting any row is
not important. He just want to go to a
specific row.
By the way, as I said, the SearchField is already there to use. We only need to design our database with a unique Primary Key.