Form Refill

[pkgal79]

i have ASP page with 3 text fields: customer no, customer name and customer phone. whenever user enters customer no.,
page reloads, take out customer name and customer address corresponding to the customer no entered from database table and fill the form fields
of customer name and address with these values.
how to prevent the page reload and perform this autofill at client side. please note that table contains more than 4000 rows.

Also, is this possible to create fields auto refill as we have in windows. I mean if my name is "sarah", the text field gets polulated
by the value at once if just enter "s"

[slyfox]

unfortunately asp cannot autofill the values at client side, rather first ask the member for "customer number" then send thru to execution page which will then get and display the information..

here is the sql statement to search "sarah" by the letter "s"

"SELECT * FROM tablename where field like 's%'"

Hope this helps