Cannot insert any records
First, I am very new at this, so please be patient.
I created a database using phpMyAdmin with a product table. After running the dataAssist wizard, I could view all the pages, search for data (I only have two records so far), view data, update data, but not insert data. When I open the insert page, fill in all the info and hit "insert" a new page opens with just one sentence (Duplicate entry '' for key 1). When I check the database, no new record has been added.
When I first created the table, I defined the first category "ProductID" as unique. I would also like to mention, that for the first category DataAssist did not generate a text field for data entry. So I added a text field in the code like this (input type="text" name="ProductID" id="ProductID" value="" size="32"), just like the other entry fields looked like. I thought with that I could fill in the ProductID, which is different for each product.
Could someone help me, and tell me what I am doing wrong?