>This seems like it would work but the result is the first record in the table.
Oops.. left out something...
...WHERE drawingno < current_no ORDER BY drawingno DESCENDING
or
SELECT MAX(drawingno) FROM mytable WHERE drawingno < current_no
I also wondered - if you are putting these in a VFP table first, why not order it by drawingno when you create the table? Then you can simply SKIP or SKIP -1...
Insanity: Doing the same thing over and over and expecting different results.