I have a table with a GUID ID column and Firstname, Surname fields. I want to be able to select a record using the GUID and also select the previous/next record sorted by the Firstname and Surname fields. So for example, i
In the example above, I want to select record c5875.... (Kevin) and have the previous/next sorted by the 2nd/3rd column and have it display John (prev) and Tracy (next).
Hope that makes sense.