I'm trying to speed up the data entry for my awards database. My "people" table currently has five fields:
peopleid first middle last display
So an entry might be:
peopleid 120
first William
middle H.
last Macy
display William H. Macy
Is there an AJAX library that you can suggest that would enable someone entering the data to type in the "display" form field and if the name's found it populates the other fields and if not found the person manually enters the name in the correct fields? I've seen some autosuggest libraries but the ones that I've found only seem to deal with the one field.
Thanks!