I am currently creating a program in ASP.net/vb.net using an sql db. I am using the id (key) column as the report number for the reports. What i want to do is on page load, create a row using an insert statement (which i have working). Then they fill in the information, and on the submit button, have it update that row that was created earlier (which i have working). My problem is that i have to use auto postback for the other checkbox on the page which will show a text box on click (thus using auto postback). when they choose the check box, it creates a new row in the db which i don’t want to have happen for the postback. is there a way to stop this from happening. I am doing it this way so that it will display the report number, and also so the report number can not be taken by any body else creating a new report, it will take the next number in line.
