[TYPO3-dev] table joins and TCA

[Elmar Hinz]

Stig N. Færch schrieb:
> But if I normalize the DB design of the extensions, then it will not be very
> compatible with the TCA, right?
> 

I thought your original concern would have been to have a normalized
table, where every selfstanding unit goes into it's own table?

That is not in contradiction to the TCA. All of your additional tables
would have a field with a pointer to the main tables uid.

The mayor problem is that of the automatic form generation. You can
select the right main table entry in each details form, but you don't
get a selectin from the main table to the details.

I have written an extension (elba), that supports an easy way for
construction of really complex joins in the TypoScript way. TCA fields
like hidden or deleted are automatically included, so you don't need
to set up most parts of the joins by hand. Only special parts of it
like search strings.

Regards

Elmar