[TYPO3-dev] tca foreign_table

[Tania Morales]

Hello,
I'm trying to display a list of items that are related in 3 tables like this
"config" => Array (
            "type" => "select",
            "foreign_table" => "tx_tableA,tx_tableB",
            "foreign_table_where" => "AND
tx_tableA.uid=tx_tableB.uid_foreign AND tx_tableB.property=10  ORDER BY
tx_tableA.item",
            "size" => 15,
            "minitems" => 0,
            "maxitems" => 5,
            "MM" => "pages_tx_tableA_mm",

So the final result will be a list of items from tx_tableA that exists in
the tx_tableB where the property is 10. And when you select one, it will be
saved in the pages_tx_tableA_mm.

But I'm getting a mysql syntax error, and it seems that foreign_table can
not handle 2 tables. Please let me know if you have any idea of what I'm
doing wrong.
Thanks
-- 
T at ni@