APEX

Greetings:

I have used this site in the past and it has been a great experience. I am writing because I am trying to develop a special application for a customer and I am stumped. I looked around in the forums and online and have not found an answer for this.

It is a complex problem, so I'll divide it into two parts:

- The form has several fields, including name, employee number and social security number.
The form acts as both a search (for the name, emp_no and SS) as well as a data entry form for another table. The idea behind this is to emulate the function that Access has (it is an autocomplete of sorts, where you input either the SS or emp_no and get back the values for Name, emp_no and SS, so then the rest of the form gets manually filled out).

- The submit for this form has to be when they move focus from whatever field they were looking for.

I am thinking AJAX for the first part and some javascript with focus behavior for the other. What do you guys think?