[TYPO3-dev] table joins and TCA

[Martin Kutschker]

Stig N. Færch schrieb:
>>>No, it's 1:1 for each master/detail table pair: for each master record
>>>exists (at most) one detail record and each detail record belongs to 
>>>exactly one master record.
>>>
>>
>>Hi Masi,
>>
>>My "master-detail" expression was too restrictive, i was meaning : all 
>>external records in relationship with the record you display in the BE 
>>through TCEforms.
>>Could we just enhance TCA so that it's able to manage foreign keys without 
>>modifying the primary table ?
>>
>>- Table Events => uid[event] of the calendar event = pk
>>- Table Bookings => uid[booking] = pk
>>- Table Events-mm-Bookings => pk = [fk(uid[event], fk(uid[booking])]
>>
>>In that case, it could be possible to create, modify, delete associations 
>>with Bookings when you edit the Event record in the BE.
> 
> 
> I'm sorry that I haven't been able to express precisely enough what I mean.
> I might not have a suffiecient insight in the different tems to describe it.
> 
> Anyway, what you describe sounds what I'm looking for :-)

I haven't followed the recent MM-thread. But this is I think what it was 
about. An MM-realtion that can be accessed via TCE-form (ie the TYPO3 BE) 
from records on both sides of the relation (no local/master-foreign/detail 
tables, but table1-table2).

I recal that there were patches made for such a setup.

Masi