I am attempting to setup a form that will allow me to add records to the database. The first field in the database is called "ID" and it is the primary key. According to the book I have (PHP Web Development with Macromedia Dreamweaver MX 2004 by Allan Kent and David Powers with Rachel Andrew) when I create the "Insert Record Server Behavior" it should show me that 'ID' is an Unused Primary Key and then whenever I submit the form the enter a new row in the database it should automatically generate the next number.

However - instead of generating the next number it only wants to generate '0'. Since I already have a row with the ID of 0 it of course is showing as a duplicate error whenever I try to add a new record. Any ideas on how to fix this?

Thanks,
Tracy

Nevermind - I needed to setup the field in the database to "autoincrement"