[TYPO3-dev] table joins and TCA

[Stig N. Færch]

Maybe this is possible maybe it's not. I haven't found how to do it anyway. 
I'm sorry if I didn't my research good enough.

Anyway. This is my intension.
I want to extend a calendar extension with several groups of functions.
One would be booking of rooms.
Another would be vacation management.
Another would be adding specific information related to events in a church.

Instead of just adding lots of fields to the calendars table, I would create 
new table for each subextension, and then connect them with joins.
Just like this: http://www.w3schools.com/sql/sql_join.asp

Wouldn't this be the suggested way to do it from a database viewpoint?

But anyway, I can't see that the TCA can handle this in a nice manner.
The ideal way would be that each subextension had it's own tab in Be.

Have I overlooked anything?

Thanks in advance.

/Stig