I have a aspx page with several fields. These fields are the user name email phone etc...
"The header section of an order"
There also is approximately 50 items the user can request.
I want to write the header section into a table called orders. and return the order number.
I then will write the items requested into a second table "With the order#"
The order number will be generated when the record is added.
So..... My question is how do I ensure I get the order number for the order I just submitted.