Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Dynamic Data in HTML Form 1

Status
Not open for further replies.

Bkster

Technical User
Joined
Jan 25, 2002
Messages
94
Location
US
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

 
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
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top