title: How to display multiple columns as a list in a ComboBox?
body: <p>I want to display multiple, specific columns in a combo box and use it as a search parameter for a query. Any ideas if that's something I can do?</p>
  
  <p>I'll give an example of my table below:</p>
  
  <pre><code>Company Name    Document    Notes    2nd Document    Notes 2
  A               1           test     2               test
  B               1           test     2               test
  C               1           test     2               test
  D               1           test     2               test
  </code></pre>
  
  <p>I have a combobox parameter set up that searches a query via the company name. 
  So if I select 'A' in my first Combo Box; the results would return:</p>
  
  <pre><code>Company Name    Document    Notes    2nd Document    Notes 2
  A               1           test     2               test
  </code></pre>
  
  <p>I want the next combo box to display the 'Document' column and the '2nd Document' column; essentially displaying a list of documents for a specific company. </p>
  
  <p>Then once a document is selected; I would like a textbox to display the next column over from it.</p>
  
  <p>For example</p>
  
  <pre><code>Combo box 1     Combo box 2           txt box:
  'A' selected    '2' selected          Displays text from 'Notes 2'
  </code></pre>
  
  <p>So in a Nutshell, how can I get a combobox to display specific columns of a query result, if possible? - and how can I get a text box to display the column to the right of the selection in the previous combo box( e.g., selected '1' would display 'Notes' column, selecting '2' would display 'Notes 2' column   If not, any alternatives? Thanks!</p>
  
  <p><strong>Edit:</strong>
  I had an idea - Perhaps there is a way for a query to convert multiple, specific columns into a single list; then display that list in a combobox? </p>