When using datawindows in query mode that contains dropdowns - the value in the data column is displayed, not the display value. The data column contains the table's primary key which is a sequence no, and the display column contains f.ex. a description column.
When the column containing the dropdown has focus, the correct value being the description is displayed. But when we exit the column, the value displayed changes to the sequence no which is the data column.
Please see attachment showing an example.
This is a problem with all dropdowns when the datawindow is in query mode.
Has anyone else experienced this and found a solution?