Ideas or name of an Ajax script that does this?

[jaxdevil]

I have a form on my site that has a vendor name and address section and next to it a 'ship to' name and address section. I have used an ajax script before that will search through a database as I type and will display a drop down below the form field of the first 5 names that match that name from the database, and if you select one it fills the form with the name or ID number for that name. (sort of like ask.com does) but what I need to do is this: Each name and address section (both the vendor and ship to sections) have 6 fields (name, address, city/state/zip, phone, fax, contact) that are stored in their own databases (their is a vendor database and a 'ship to' database) the vendor database has a column for 'ship to links' where all previously 'ship to' entries are stored in the 'ship to database' and the ids for each of those are listed on the column 'ship_to_links' and separated by a delimiter ( | ). What I need is an ajax script that will first while the user is typing in the vendor name it is auto searching the vendor database and displays the first 5 entries, then is the user clicks one it auto-fills the rest of that form fields (for the vendor database) AND it selects the first ship_to id in the list of ship_tos and fills in the second form field with the data form the 'ship to' database for that first entry. If there are multiple form fields it will display a drop down field on the name of the ship to location where they can select a different one, and will allow them if they like to type in a new ship to location.

 

Anyone seen an ajax script that works similar to this?

 

Thanks in advance,

SK

[Ken2k7]

It's called an auto-completion. YUI has the functionality, but you'll need to modify it a bit.

[vbnullchar]

you can also try jquery much easier to learn