I have a two part challenge for a web form I am putting together, and I am stumped on how to accomplish what I need to.
Background: I am putting a web form together in Dreamweaver CS3 that will handle a nomination process that will ask users to rate a number of catagories for a nominee company. I have the form itself assembled, but having issues with how to create and format some information that ITS is requiring in the database.
One piece is the dbase calls for a nomination_ID value to be inserted. I had hoped to create a dbase query that pulls the highest nomination_ID value currently in the dbase, add 1, then set that as the value to be inserted with the new nomination. The reason we need to do this is because the nominator can submit several nominees for several catagories, so need to keep track of what information goes with which nomination.
I am fairly competent in using Dreamweaver, but a definite newbie when it comes to SQL. I hope to be able to get some idea of what the query should look like.
If it helps, here is a link to the nominating page: http://www.healthcaredistribution.org/membership/award_diana-50th-cat8-13-nom.asp
I am going to post the second challenge in another posting, to spread around the points. Thanks in advance!