i am trying to get a number/id from table as i open to add/edit a form which pulls and/or populates a sql 2000 db. i am able to add a new prop_id but how do i get a new unique id pulled from the new row in a table as the form opens? i am also using safileup to upload a pic, and a pdf and a wmv file which only works after i upload the data/form to the db, leave the page then reopen it and it then knows the prop_id which i have each file named after followed by the correct extension.
http://clearance.entertainmentstudio.../prop_list.asp is the work i am producing..thanks for helping or pointing me in the right direction.

greg
greg.morancey@gmail.com