In the Database, you should set the ProductID field to be a Primary Key field and set it to Auto Increment so that the database will mange the value being given to that column for you.
Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.
These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.