Link to home
Start Free TrialLog in
Avatar of Bob Schneider
Bob SchneiderFlag for United States of America

asked on

Add Auto-Fill to Classic ASP Form

We routinely have to enter participant data for races and we like to identify if a particular person exists in our system based on first name, last name, city, st, email, gender.  Note that only first name, last name, age or dob, and gender are required fields.  I would like to add a utility that provides a list of "matches" based initially on last name and then possibly filters from there as other data is entered.  At any time, I would like the person entering the data to be able to click on a choice and have all available fields auto-fill.  We use sql server 2012 as our database.

Thank you very much!
ASKER CERTIFIED SOLUTION
Avatar of Big Monty
Big Monty
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Bob Schneider

ASKER

More like the google search box
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thank you.  I will look at that.
I have been studying that and what I don't see is the way to auto-fill multiple user inputs based on a selection made from a single drop-down.  For instance if you type a last name you get a list of options that include that last name as well as other data (first name, gender, phone, email, age, etc) and selecting that item in the list populates the other inputs as well.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
It's been tough finding time this week but there is enough here to get started so I am going to follow your advice and take a "big picture" view of this, learn a more about the AJAX/JSON process, and then re-post specific questions as they arise.

Thank you all!!!
Ok great, good luck and have a good weekend :)