I have quite the dilemna this afternoon. My application performs a simple select all records from a table to initialize navigation...previous, next, first and last.
However, I now have added a routine to load the last viewed record, by the
logged on User, in the recordset. This now causes the original navigation
to not be in order.
Is it possible to perform the select all records and then position a "cursor/index/reference starting point" to a value in that recordset?
LastViewed = 5 so base all navigation off of 5...6 next record, 4 is previous record