[TYPO3-dev] table joins and TCA

[Jean-Baptiste Rio]

Martin Kutschker wrote:
> 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.

Regards,

JB