In addition, I'm trying to create an UPDATE form obviously but I'm used to the ASP/VBScript way of doing things.
The first field in my database table is LEDid which is my Primary Key.
However, when I try to create the Update Record behaviour this field appears in the list of columns as 'LEDid' Is an Unused Primary Key despite it not being a form field on my form. When I ignore it and try to create the Update Record behaviour it throws the error "Please submit at least one column as a primary key."
The Primary Key field is set to auto-increment though, plus it's unique, so I can't just "create" a primary key value because it might already exist.
What is the resolution to this?
Thank you, and thank you for guiding me through some of this PHP / MySQL stuff. Like I mentioned in a previous post, once it's in it's in and I won't bother you so much but, for now, thank you for your assistance, and patience, as it has been a great help so far.