Dynamic Data in HTML Form 1

[Bkster]

Hello,
Is there a way to do this? I have a HTML form that is going to be submitted to a database. Instead of the end user filling out every field they could enter and employee number in one field. When they tabbed out of it would look up, in the database, the employee number and then populate the specified fields, on the HTML form, ie.. Last name, first name, assignment etc... all values that are stored in employee table, that match that employee number. After these field were populated you would hit the submit button to send the data to a different database.

Thanks in advance for the help

Brian Russell

 

[schase]

Hey Brian,

Yes you can, and excuse me if my answer's a little disjointed (it's been a long week)

I think the best way to accomplish this, would be to have the initial form where the user enters an employee number - then proceeds to fill out any other info you want stored (except the employee info that you already have in a table)

You would then need to declare a session variable of the employee name, have the form submit to a confirmation page.

On the confirmation page, you would pull values through the form, then create another recordset where the employee ID = say Session("MM_EmployeeID) Then have the remaining fields on the confirmation page pull from the second recordset.

At this point another submit which sends to the second database.

"If you feel a post has been helpful to you, click on the link at the bottom of their post to cast a vote for "TipMaster Of The Week". You don't need to be the one who asked the question to vote"

Stuart

 

[schase]

Sorry Brian, I mis-did the session part. Take a look at Tony's Post regarding passing URL values and session variables.

"If you feel a post has been helpful to you, click on the link at the bottom of their post to cast a vote for "TipMaster Of The Week". You don't need to be the one who asked the question to vote"

Stuart