I need to go to a certain record in a DBLookUpComboBox...
So I have 2 tables ,
the first one is called tableone has the fields:
soc,name (soc is primary key and it's string)
the second one named tabletwo and has the fields
date, id, no, soc (id is primary key)
Tableone is connected with a datasource to a DBLOOKUPCOMBOBOX showing the "name" field
and tabletwo (through a query) is connected to a DBGrid
When the user selects (doubleclicks) a record in the DBGrid I must show the corresponding value in the DBLookUpComboBox
How can I do that?