[TYPO3] FCE's and values from foreign tables

[John Kavanagh]

Hi,

 

I have added a select box to my flexible content element so that a value
from a foreign table can be selected. It is all working fine in the
backend but in the frontend: only the uid of the item is shown instead
of the title. My xml is as follows:

 

....

      <field_type type="array">

        <tx_templavoila type="array">

          <title>type</title>

          <sample_data type="array">

            <numIndex index="0"></numIndex>

          </sample_data>

          <eType>select</eType>

        </tx_templavoila>

        <TCEforms type="array">

          <config type="array">

            <type>select</type>

            <foreign_table>tx_product_type</foreign_table>

                             <foreign_field>typename</foreign_field>

                             <foreign_label>typename</foreign_label>

 
<foreign_selector>typename</foreign_selector>

                                      <foreign_table_where>ORDER by
tx_product_type.typename</foreign_table_where>

            <size>5</size>

            <maxitems>1</maxitems>

          </config>

          <label>type</label>

        </TCEforms>

      </field_type> 

 

....

 

What must I add?

I have trawled through the documentation and the mailing lists but have
found nothing!

 

Thanks,

 

John.