On many apps, the order number is not typically shown until the order is submitted (or data has been completed keyed) because it is not a valid order until then. Once that is done, then the order number is displayed.
>>It's quite easy. You generate the primary key (a guid) on the client/web server, not on the database server. You have the order number as auto incrementing. You save the record, and requery it using the generated primary key.
>
>How can you show the number on the form when you're working on the order? You still should have an ability to Cancel.
.·*´¨)
.·`TCH
(..·*
010000110101001101101000011000010111001001110000010011110111001001000010011101010111001101110100
"When the debate is lost, slander becomes the tool of the loser." - Socrates
Vita contingit, Vive cum eo. (Life Happens, Live With it.)
"Life is not measured by the number of breaths we take, but by the moments that take our breath away." -- author unknown
"De omnibus dubitandum"