title: Show a name instead of an id
body: <p>I currently have these options set in a combo box:</p>
  <p><a href="https://i.stack.imgur.com/aEJeH.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/aEJeH.png" alt="enter image description here" /></a></p>
  <p>This box will show the projectIDs that a current company has which is set with the criteria. I just want to show the name of the project as people will not know just by the id. If I remove the check box for the projectID it will just remove that field completly and not show anything. I have debugged what companyBox.Value is and it is indeed a number for a company and if taken this id and replaced it with the following query which is built from the picture and it returns the results I want. I just cant get the values to show in the combo box.</p>
  <pre><code>SELECT projects.projectName
  FROM companys INNER JOIN projects ON companys.companyID = projects.companyID
  WHERE (((companys.companyID)=7));
  </code></pre>
  <p>Gives me all the projectNames where the companyID is 7</p>
  <p><a href="https://i.stack.imgur.com/IkIu1.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/IkIu1.png" alt="enter image description here" /></a></p>
  <p>And as seen below that same query just gives me blank spaces instead of the names:</p>
  <p><a href="https://i.stack.imgur.com/2qHMG.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/2qHMG.png" alt="enter image description here" /></a></p>