I have a Patient intake form which takes Patient information like FIRSTNAME, LASTNAME, DATE OF BIRTH, ADDRESS, CITY, and POSTAL CODE.
When a user enters FIRSTNAME, LASTNAME and DATE OF BIRTH it should fill the rest of the fields (ADDRESS, CITY, POSTAL CODE) if I have a record in my database.
I am using JAVA with MYSQL and I pull records when a user leaves DATE OF BIRTH textbox.
I don’t know weather I should store everything in a dropdown or I should have a separate form for the matched records from where the user can click the record and fill the rest of the fields.
Any ideas, suggestions or samples?