title: TYPO3 foreign_table: How to specify a specific column to a select drop down menu?
body: <p>I want to add records in the TYPO3 backend. For that I made an extension containing 4 different classes. While adding a record of one specific class to a folder via the backend I want to have a select that lets me chose from items of a column from another class. I know I have to use a <code>foreign_table</code> for this like in this code:</p>
  
  <pre><code> 'kundeuid' =&gt; array(
                     'exclude' =&gt; 1,
                     'label' =&gt; 'LLL:EXT:icingaconfgen/Resources/Private/Language/locallang_db.xlf:tx_icingaconfgen_domain_model_appliance.kundeuid',
                     'config' =&gt; array(
                                     'type' =&gt; 'select',
                                     'renderType' =&gt; 'selectSingle',
                                     'foreign_table' =&gt; 'tx_icingaconfgen_domain_model_kunde',
                                     'foreign_table_where' =&gt; 'ORDER BY tx_icingaconfgen_domain_model_kunde.kundeuid asc',
                                     'items' =&gt; array(
                                                     array('-- Select Kunde --', 0),
                                     ),
                                     'size' =&gt; 1,
                                     'maxitems' =&gt; 1
                     ),
             ),
  </code></pre>
  
  <p>But the problem is I can't specify that the selection should only include properties of a determined column. Instead the select drop down menu seems to use properties of the very first column. How can I specify the column of the 'kundeuid' property?</p>
  
  <p>Edit: I forgot to mention, the code is used in the specific PHP file in the TCA folder.</p>