Hi Penny,

Can you confirm that the column names you typed into the Lookup page for the Employee Number and Department are valid?

This works for me, unless I'm misunderstanding your configuration. To confirm, when you run that stored procedure without any parameters, it is supposed to return a listing of employees and the corresponding values for the FullName, EMPLOYEE, and PROCESS_LEVEL columns (as shown below)?

And your form has three drop down fields named Employee Name, Employee Number, and Department which are supposed to have their values coming from the execution of that stored procedure?

The drop down fields in my form have all their available values coming from that stored procedure.

If there is still an issue, despite the configuration appearing to be correct, please contact your Laserfiche reseller to open a support case.

If your actual goal is to make it such that the Employee Name drop down is populated with the values of FullName and then once an Employee Name is selected, the corresponding Employee Number and Department are to be filled out, then you'll have to reconfigure your lookup rules. First, this won't work by calling a stored procedure. Instead, you'll want to consider creating a separate table/view of the data you're retrieving and then configure the lookup based off of that.