Matthew,
I actually did this very thing. In a nutshell this is what I did. Try the site
www.dejavucollectibles.com
1) Create a table in your db that generates a sequencial number. This number will be unique as every time a visitor visits the site one will be created. Use it as your order number.
2) Read your table(s) and create a item record.
3) Display the item record in an HTML page
4) Create another recordset object for the shopping cart
5) User browses the page, clicks on the desired item, that updates the recordset on #4
6) At the end user confirms order and you update the temporary order table
7) User enters personal information
8) Send e-mail to user with the order
9) Update your permanent tables