foreign_table

foreign_table
Type:string (table name)
Scope:Proc. / Display
RenderType:all

The item-array will be filled with records from the table defined here. The table must have a TCA definition.

The uids of the chosen records will be saved in a comma separated list by default.

Use property MM <columns-select-properties-mm> to store the values in an intermediate MM table instead.

Deprecated since version 11.2: Usage of the foreign_table relation with the table sys_language Has been deprecated. Use TCA field type called language instead.

Examples

Select singe field with enabled selectIcons

../../../../_images/SelectSingle12.png
'columns' => [
    'select_single_12' => [
        'exclude' => 1,
        'label' => 'select_single_12 foreign_table selicon_field',
        'config' => [
            'type' => 'select',
            'renderType' => 'selectSingle',
            'foreign_table' => 'tx_styleguide_elements_select_single_12_foreign',
            'fieldWizard' => [
                'selectIcons' => [
                    'disabled' => false,
                ],
            ],
        ],
    ],
]

Select field with foreign table via MM table

../../../../_images/SelectSingle15.png
'columns' => [
    'select_single_15' => [
        'exclude' => 1,
        'label' => 'select_single_15 foreign_table',
        'config' => [
            'type' => 'select',
            'renderType' => 'selectSingle',
            'foreign_table' => 'tx_styleguide_staticdata',
            'MM' => 'tx_styleguide_elements_select_single_15_mm',
        ],
    ],
]