Stepping through records

[Lau renz]

Dear Sirs,

we have a database filled with over a million records and like to implement
a "live display" of selected rows. That means, when changing rows our program should refresh the according data immediately.
The sorting (Index) is ensured by means of a "group-by” function. When you select another row, via the up- or down-key, the accordant data from our database should be reloaded! This is necessary, cause in the meantime the data could be changed by another user.

So, we can't work with a fixed set of table-data (result-set) and we can´t just save the unique id's for a refresh because it's possible that the next row has been deleted/changed or a new one is inserted in between them.

Is there a possibility to handle this functionality?

Sincerely,
Laurenz