[sasi]

i have a registration form where the student must enter their personal info(will be inserted in a personal_info table)then the student have 2 proceed and fill up the next form by entering what subjects he would like 2 take....now the problem is i dont know how to retrieve the identity number that has been entered in the previous form(personal info) to be inserted in the subject table...plz help...

[Mister B.]

one way would be to when he logs in (or in this case when he has filled out the form) put a cookie on his comp with his # on it, then you call it from there.

[Xtremist]

when you have the information submitted into the DB, have that page with the insert statement redirect to the next page based on a select statement that uses the users name and password. It would get the ID for you and you could pass it on to the next page using a querystring.

So, Page 1 has the form where they enter the info. It submits to page 2.

Page 2 has all the insert statements and then it has a select statement based on the name, password, zip.... whatever... just need some way to identify them... you could even go as far as using a random number.

Then page 2 has a response.redirect using the ID to the rest of your form.