Symptoms

When I do transfer data, I can set a drop-down list control when I enter text, but when I drag from a smart object or another control, it doesn't work.
 

Diagnoses

When configuring a drop down list control with a SmartObject data source, it is usually configured with a 'Value' and a 'Display'. A matching 'Value' will need to passed to the drop-down list control (instead of the display value) to change it to the correct 'Display'. It was determined that the SQL row had been created char data type instead of nvarchar data type, and as such the string 'DENALLIXMike_______' was passed into the drop-down list control from another control instead of 'DENALLIXMike' (which was what the drop-down list control was expecting) and as such the drop-down list control did not change as needed.
 

Resolution

After changing the SQL data type as well as trimming the underscore from the existing data, the drop-down list is now populating as expected.