[TYPO3-dev] table joins and TCA

[Stig N. Færch]

"Elmar Hinz" <elmar.DOT.hinz at team.MINUS.red.DOT.net> skrev i en meddelelse 
news:mailman.1.1142359055.7700.typo3-dev at lists.netfielders.de...
> 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?

By unit you mean?
Normalizing is about avoiding redundant data. Or am I wrong?

> 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 guess my TYPO3 programming skills are getting very rusty. Unfortunately I 
only program in my spare time. And it has been a while since I did a new 
extension from bottom and up. :-(
Any chance you can cut this out for me. Not entirely sure what you mean 
here.

> 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.

Sounds interesting. :-)

/Stig