Im not assigning a value to the ID column.
Ive attached the Insert Record Wizard listing in gif format for you to see.
Ive also attached a copy of the insert file for you as well.
The record insert file contains digital file pro image upload fields as well, however ive regenerated a new insert form using the Data Assist Wizard to test it with and its just writing the same ID numbers as before.
When you try to insert a product it appears in the database as ID 214xxxxx instead of the next number in sequence and instead of going to the detail page, it returns to the insert page along with this error message at the top of the screen:
Warning: Cannot modify header information - headers already sent by (output started at /home/barkerde/public_html/admin/productimport_Insert.php:142) in /home/barkerde/public_html/admin/productimport_Insert.php on line 169