So I believe I have cleared anything writing to the OrderID column. There should be nothing writing to it but i still get a - Duplicate entry '29' for key 'PRIMARY' when I try to add more than one product to the cart. It should be working now shouldn't it?
Are you sure it's the "Orders" table that is causing the error? Not the Order Details? That is where it seems to be trying to write the individual detail lines of an order and crashing.
Thanks for helping on this one. Just need to get this one last part working.Cheers!