[TYPO3-dev] Multilingual database relation

[Rudy Gnodde]

Hello everyone,

I am working on an extension and have run into a problem. I have 2 
database tables: region and project. Both can be localized. In a project 
you can select which regions the project is linked to. This all works 
fine except for one this.

When creating or editing a project you should only be able to select 
regions from the same language as the project. It currently shows all 
regions in all languages. Is this possible?

The code for the regions field in the project in tca.php (created by the 
kickstarter) is:

"regions" => Array (
   "exclude" => 1,
   "label" => 
"LLL:EXT:afew_regions/locallang_db.xml:tx_afewregions_project.regions",
   "config" => Array (
     "type" => "select",
     "foreign_table" => "tx_afewregions_region",
     "foreign_table_where" => "AND 
tx_afewregions_region.pid=###CURRENT_PID### ORDER BY 
tx_afewregions_region.uid",
     "size" => 5,
     "minitems" => 0,
     "maxitems" => 99,
     "MM" => "tx_afewregions_project_regions_mm",
   )
),

Regards,

Rudy Gnodde
WIND Internet