Auto Completing Form Fields in Data Input form

[uk_martin]

Hi



I'm trying to see if there is a way of saving time and errors in the automated inputting of name and address information in a data input form.

At the moment, the form has all the input filelds in "text box" format, and they transfer the information to a data table. There are input fields for first name, surname, company, address 1 etc etc What I want to be able to do, is to select the "company" from a drop-down box, with information fed from the main data table, and when selected, the information in the other input fields (or those selected to do so) display the rest of the information (first name, surname etc)

The combo box needs to be able to accept new entries too, as new customers will always come along, however, once inputted into the table, it should be "findable" for the next time that this customer contacts us.

Is this concept possible and how can it be done?

Thanks

Martin

[pbaldy]

How about this:

http://www.baldyweb.com/Autofill.htm

For the second, search on "notinlist" which should help with the new ones.

[uk_martin]

Thanks for the link. the form now does what I want it to do.

[pbaldy]

Happy to help.