Java popup to access DB and return value to form field
I am trying to build a data entry web page. One of the fields should select from a database table of about 200 entries. Each entry is also a long piece of text so I don't think I can make it a drop down list; ie too confusing to browse in a small list window.
I was thinking of making the input field clickable and it pops up a new window. The new window lists all the rows from the database table (the text portion). User clicks on the text, window closes, and the row id is returned to the input field.
Is there a better way to do this? What is normally done? I googled for some code but nothing along the lines of what I wanted to do.