Thanks Jason. I think I have the idea.
I can take the recordset that the cart already uses:
<%' WA eCart Store Cart Details in Db
if (Request.ServerVariables("Request_Method") = "POST") then
WA_connection = MM_connBBT_STRING
WA_table = "dbo.OrderDetails"
WA_redirectURL = ""
WA_indexField = "DetailOrderID"
WA_fieldNamesStr = "regID|DetailDate|DetailOrderID|DetailItemID|DTitle|Description|Quantity|Day|Time|AttendeeName|Preg|PregTerm|GolfClubs|TennisRac|InventoryORD" .......
And copy that, edit the SQL to subtract the Quanity from the inventory
then loop that recordset with an update behavior in there.
Would I still use the if (Request.ServerVariables("Request_Method") = "POST") then
to have the update post when the submit order button is pressed?
thx
Eric