>In a form I type in a Number that represents a drawing number. Code activates and this number is searched for on a remote database and returns information accociated with the number. Also on the form are left and right navigation buttons. I want to use these buttons to go to the next drawing number on the remote database or previous drawing number. It is easy to add or subtract 1 from the current number and search again when all the drawing numbers are the same length. However, the drawing numbers very. I maight have 840000, 840001-401,840001-402,840002,840003-401,840003-403,840004-001,840005,840006 in a series of numbers. Do you see my problem? Localy I don't know what the next drawing number will be but I need the next one to display when I click the nav button. Thanks for the help.
This sounds familiar... :)
What's the remote database - VFP, SQL Server, Oracle, etc.?
What's the lookup code doing now?
Sounds like simply getting the next value where the drawing number is greater than the current drawing number would work...
e.g. - modify for remote use...
lcCurrent = mycursor.drawingno
SELECT TOP 1 * FROM mytable WHERE drawingno > lcCurrent
Insanity: Doing the same thing over and over and expecting different results.