title: Delphi 7 ADO, DBGrid combobox field
body: <p>I have these tables in my MySQL database:</p>
  
  <p><img src="https://i.stack.imgur.com/fC4hl.png" alt="enter image description here"></p>
  
  <p>I want to display the employee table and job.jobName in DBGrid and allow user to edit it (using DBNavigator maybe). </p>
  
  <p>So I created an ADOQuery with SELECT ... JOIN query, a DataSource and linked a DBGrid DataSource to it.
   <img src="https://i.stack.imgur.com/wMx7a.png" alt="enter image description here"></p>
  
  <p>Everything works, but instead of jobId field I want Job field which displays JobNames, allows to choose it via combobox and sets id in the employee.JobId.
  Something like this:
  <img src="https://i.stack.imgur.com/vTAYs.png" alt="enter image description here"></p>
  
  <p>I thought that I can achieve it using LookupKeyFields/LookupResultFields properties for JobId field in ADOQuery but in fact it doesn't work for me.</p>
  
  <p>I added an ADOTable which just loads everything from the job table and set JobId field (in ADOQuery) properties: FieldKind = <strong>fkLookup</strong>, KeyFields = <strong>JobId</strong>, LookupDataSet = <strong>tblJob</strong>, LookupKeyFields = <strong>IdJob</strong>, LookupResultFields = <strong>JobName</strong>.</p>
  
  <p><img src="https://i.stack.imgur.com/HnWsh.png" alt="enter image description here"></p>
  
  <p>But now Job column is just empty and without comboboxes. </p>
  
  <p>Also I found PickList property in DBGrid columns, but it is TStrings, so it allows only displayed string, not separate displayed strings and values. And it did nothing even when I tried to fill it for string field (LastName).</p>