The form has two queries and data sets, both based on the same MySQL table. Data from one query is displayed in a DBGrid, and from the other (as ListSource and ListField) in a DBLookupComboBox. The ComboBox's DataSource is set to the data source of the grid, and the DataField and KeyField are set to the same field (ShareNo). ScrollListData is set to true.
What I expected to happen was that selecting an entry in the combo box would scroll the grid to the corresponding row. What actually happens is that the key field value corresponding to the selection in the combo box is put into the ShareNo column of the current row in the grid, overwriting the value that is there.
In the screen shot, Brzezinski has been selected, but instead of scrolling to his row (341), his ShareNo has overwritten Conway's (1).
Am I misunderstanding how it should work, not doing it properly, or is it broken?