Thank you for the tip, it's little stuff like that that causes hours of frustration.

I think my worst example of that is when I use <> XXX criteria in...

Oh, great, so, when it creates a new record it sets the order_no to Max(order_no BETWEEN @MinProduct and @MaxProduct) + 1

Where @MinProduct is:

Case Product

Case A

     000000

Case B

     100000

Case C

     200000

Case...