foreign_table¶

foreign_table (type => select)¶

Path: $GLOBALS['TCA'][$table]['columns'][$field]['config']
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¶

EXT:styleguide/Configuration/TCA/tx_styleguide_elements_select.php¶

[
    'columns' => [
        'select_single_12' => [
            '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¶

EXT:styleguide/Configuration/TCA/tx_styleguide_elements_select.php¶

[
    'columns' => [
        'select_single_15' => [
            'label' => 'select_single_15 foreign_table',
            'config' => [
                'type' => 'select',
                'renderType' => 'selectSingle',
                'foreign_table' => 'tx_styleguide_staticdata',
                'MM' => 'tx_styleguide_elements_select_single_15_mm',
            ],
        ],
    ],
]