insert record problem
I'm struggling with a problem that I can't fix. I wonder if anyone here can help. I'm not familiar with php and databases, so I shooting in the dark with trying to figure out what's going wrong.
I have successfully made a search page that works (thanks to a little help on this forum) and displays the results, I can edit and update records and so on, but the one thing I can't get to work is the insert record function. It will update the database, but it won't increment the primary key, which is a field called ID. What comes straight out of the wizard shows as a NULL in the ID column when you check the database. Therefore you can't view the record etc. I managed, not sure how, by hacking around with the code to get it to enter a 0 in the field and this allowed me to view the resulting record, but it needs to incerment the number obviously.
I've attached the files produced by the wizard. This is the result of just running it without making any of the changes I need... it should be a clean version of what comes out of the wizard.
If anyone can have a look, that would be great. I have looked at the insert record server behaviour but I don't really understand it. It says if you want to ignore a column leave it blank. The ID is blank but that's how it came out of the wizard. I tried putting in WADAInsertRecordID, which sounded promising, but that only meant it would add a 0 and not increment the ID number.