Software: Dreamweaver MX,
Server: Apache, PHP 4.1.2, MySQL 3.23.42.

My connection works fine, but when I try to create an 'Insert Record' page using the server behaviors, when I choose the table, it lists all of my fields but for each field says:

'primary_key' Is An Unused Primary Key
'any_field_name' Does Not Get a Value

I thought it might be because my database was empty, but even when I filled it with testing info it gives me the same problem. I can create record sets and they populate with the live data view so I don't know what the problem is!

Very Frustrated,
Justin<b></b><b></b>

Are your field names in your form the same as in your MySQL table? If they are DWMX should automatically assign values.

If they arent the same then you will have to manually assign values to each field, click on the field in "Colums"and in the drop down list below choose which form value you wish the data to correspond with.

HTH

EC

<font face='Verdana'>I didn't realize that I needed to create the form with all the fields/field names first. Once I created the form with fields that EXACTLY match the fields from my recordset it worked fine. Thanks for the reply</font id='Verdana'>