[TYPO3-dev] TCA "group" over 2 fields

[Frank Weindel]

Hi All,

I'd like to allow each of the rows of one table (A) link to a single row 
of another table (B). Right now this is working fine with using the 
"group" TCA type. The problem is that it stores both the table name and 
uid in the same field like this: "tt_news_111", "tt_content_23". I need 
to join a subset of rows from B to the rows from A. Right now I have to 
create a temporary table with rows like CONCAT('tt_news_', uid) so I can 
perform the join properly.

This kind of slows things down. So to put it simply is there a way to 
separate the record table name and record uid into seperate columns? But 
have them both appear as one "group" entry in the TCA form? This would 
greatly ease my joining pain. I know this can be done with an M-M table, 
but this is a M-1 relation and a separate table should not be necessary.

Thanks,

Frank Weindel