[TYPO3-dev] table joins and TCA

[Stig N. Færch]

>> 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 :-)

/Stig