Show Employee Name when Empl ID is typed in form

[pinto19]

Hello all,
Need your help. I am creating a form page using FP where some one could type in employee ID, and name and some other info and save. I can get this done by saving the page in .asp and info will be saved to a db. What I want to do is that when they type in the employee id in the ID box, the name corresponding to that ID will be populated in the Name field. I have a list of employees and their ID numbers saved on an Excel file.
What would be the easiest way of doing this as I have very little scripting knowledge of anykind. I can make pages using MSFP. That's about it.
Any help or codes will be appreciated.
Thanks

 

[BabyJeffy]

I would suggest you use XMLHTTP to solve this. That way you won't have to refresh the page. This is commonly referred to as AJAX (and googling for that is going to give you better results than for XMLHTTP).

What would be the easiest way of doing this as I have very little scripting knowledge of anykind. I can make pages using MSFP.

I don't see an easier way for you to do this (there are other ways but none of them easy - and none of them better). You may find this right out of your league.

Cheers,
Jeff

[tt]Jeff's Page [/tt][tt]@[/tt][tt] Code Couch

http://www.codecouch.com/jeff/

[/tt]

 

[jemminger]

if you know enough to make an input form in ASP, why not then make a similar form to perform a select query based on the collected id?

-jeff

http://www.jeffemminger.com

try { succeed(); } catch(E) { tryAgain(); } finally { rtfm(); }
i like your sleeves...they're real big

 

[pinto19]

I know how to show the inputed data in an asp page. I dont know how to pull data inside a form from a database that can be save into a different database, if that make sense.

I am open to any suggestion and guidence
Thanks

 

[jemminger]

perhaps try the frontpage forum256 and ask how to make a page that selects records from an access db

it's pretty easy in asp once you learn the ropes... you could also google "asp tutorial"

-jeff

http://www.jeffemminger.com

try { succeed(); } catch(E) { tryAgain(); } finally { rtfm(); }
i like your sleeves...they're real big