>Mark,
>I took all the drawing numbers and copied them into a local table. When I click the next nav button I run the Top 1 Select statement on the local table then take the result and do my pass-through this works great for next numbers. However, I am running into trouble going backwards. Top -1 doesn't work. How do I find the next one back?
...WHERE drawingno < current_no...
Insanity: Doing the same thing over and over and expecting different results.