Hi Leigh,

I'm not sure about the specifics of your process, but it sounds like you may need a combination of lookup rules in Forms:

1. Lookup rule with some unspecified match condition (or possibly none at all) that populates the dropdown list with the employee names from the stored procedure.
2. Lookup rule which matches the employee name and populates the other fields with the additional data (e.g. job title).

Then Rule 1 prepares the dropdown for the user to pick an employee, and once they select an employee, Rule 2 kicks in and fills out the rest of the information.

Hope this helps! If you need a more detailed example of implementing this, let me know.

Edit: Actually thinking about it, it may be that your stored procedure as-is need only return the employee names and not the other data. (Unless of course, you reuse this in a number of ways elsewhere.) For Rule 2, you would need another stored procedure that can take the employee name as the input and return the other values. If you can set up a table or view with all of the information, you could probably use that for both lookup rules instead of needing separate stored procedures for each one.