bring in more then one field to combobox

[DAVIDPOWELL]

I need to bring in more than one field into the combobox but only display one field so, i can grab the other values from the selected item and add them to my patch statement.

Items:

Sort(Distinct('[dbo].[employee_directory]',EMPLOYEE_NAME),Result)

Need to also bring in

EMAIL_ADDRESS

SFXID

OnChange:

Patch('[dbo].[Entity_Base_Information]',LookUp( '[dbo].[Entity_Base_Information]',
ID_Num = Value(ID_NUM_LBL.Text)),
{QB_NAME: NewQb_name_ddwn_cbo.Selected.Result

}

)

thanks

Dave

[Jeff_Thorpe · Accepted solution]

The Distinct() is causing the issue. Does the employee_directory table have duplicate employee records that would require you to use Distinct?

If you need to use Distinct on that SQL table then it might be easier to create a view in the SQL and then use that view to populate Items property. The SQL view will allow you to run a Distinct on multiple columns and all the heavy lifting will be done on the server side This will return three fields and then you display the Employee Name in the Combo box.

SQL Example:
SELECT DISTINCT EMPLOYEE_NAME, EMAIL_ADDRESS, SFXID
FROM employee_directory
ORDER BY EMPLOYEE_NAME