I have a table of Shop Floor information. The table is sorted by Shop Order Number and Operation number.
The operation numbers are not sequential. They may be, for example:
Is there a way to select an operation (say 47) and find the next lowest number, which would be 45?
Thank you in advance for your help.