I followed your suggestions above and added the cart summary and store cart details server behaviors to the confirm page, and it works well, with just one problem. In the orderdetails table the DetailID is doubling up. What I mean by this is that when you enter the first order (after truncating the tables) the DetailID = 2, then when you add the next order the DetailID = 4 and so on.
The orders table is fine with no problems and are numbering correctly.
I have attached the confirm page for you to view.