Chad,
Sorry if I was not clear. I mean that all code was in PSEUDO code.
So, the example could also be the following:
1) A user will fill a form with "date", "product", "quantity".
2) A form completion event will do a "INSERT INTO tbl_orders date (date, product, quantity) VALUES ('$(date)','$(product)','$(quantity)' )"
3) A second form completion event which will Redirect the user to: http://mydomain.com/page.aspx?order...(order_id)
How can I retrieve the order_id from the Database to put it in the Redirect URL?
TABLE tbl_orders
user_id (int, auto-increment, private-key)
date (datetime)
product (varchar)
quantity (int)