>NewID() Is the default value for the OrderId in the Orders table.
>It inserts and creates the OrderID fine. In order to get the web site to work I have had to convert all my tables into Access (oh dear)
>I'm just waiting for the problems to start.
>Is there any software designed around FoxPro that has a shopping cart and payment processing for the UK?
>
>It looks as if I spent £407 on Drumbeat when I should have upgraded to VFP 6.0 and bought Rick Strahls Web software.

That's your problem. The default doesn't fire from the ODBC driver.