Hello, there,
An automated number system for a multiple-part order needs to be created, so that when a new order is entered, the next avaialble number comes up; then, if there is more than one part to an order, each will get a letter(A, B, C, etc.)
The original OrderNumber like:
001-1
002-1
002-0
003-0
how to get auto-orderNumber like this:
001-1
001A-1
001B-1
001C-1
...
002-1
002A-1
002B-1
002C-1
...
002-0
002A-0
002B-0
002C-0
002D-0
...
003-0
003A-0
003B-0
003C-0
003D-0
...
Thanks for your advance.
Wdu
An automated number system for a multiple-part order needs to be created, so that when a new order is entered, the next avaialble number comes up; then, if there is more than one part to an order, each will get a letter(A, B, C, etc.)
The original OrderNumber like:
001-1
002-1
002-0
003-0
how to get auto-orderNumber like this:
001-1
001A-1
001B-1
001C-1
...
002-1
002A-1
002B-1
002C-1
...
002-0
002A-0
002B-0
002C-0
002D-0
...
003-0
003A-0
003B-0
003C-0
003D-0
...
Thanks for your advance.
Wdu