[TYPO3-irre] IRRE Problem with tree tables in combination: parent-child-subchild

[Oliver Hader]

Hi Stefan,

Stefan Frömken schrieb:
> Hello newsgroup,
> 
> OK...let's try in english. Let me know if there is something not 
> understandable.
> 
> We're a producer of high speed printers. Just look at the date of your 
> water-bottle, or what ever and if the date is dotted...it could be our 
> system.
> 
> But now back to the problem
> 
> I have a table with our printers (serialnumber, type, cutomer, ...).
> Each printer have one or more printerheads (Table: printerhead: 
> serialnumber, type, pressure, power).
> 
> Till now, there are no problems and with the help of property 
> useCombination and a intermediate table I can edit the printer AND the 
> printerhead at the same time or define a new printerhead.
> 
> But as you can see, there is a field "type" in the printerhead-table.
> I have a third table called printerheadtype. I don't know how to add 
> this table in this IRRE-system.

Let's get an overview:

You have the following objects/tables:
* printer
* printerHead
* printerHeadType

Relations:
printer <--[m:n]--> printerHead
printerHead <--[m:n]--> printerHeadType

Is that correct?

Which TYPO3 release are you using?
The combined view will not work in a nested scenario (combined view 
nested in another combined view). If you have two printerHead records 
which use the same printerHeadType, this also will break because the 
same printerHeadType record will be rendered twice.

Maybe it could help in your situation to put the printerHeadType into 
the intermediate table as an attribute (see page 27 of the IRRE 
compendium [1]) which means:

printer_head_rel --[1:n]--> printer_head_type_rel
   ^           ^               ^
   |1:n        |1:n            |1:n
*printer*   *printerHead*   *printerHeadType*

But I don't know if this fits your scenario and if you'd like to reuse 
the printer/printerHead relationship. Otherwise, possibly a regular 1:n 
relation to printerHeadType is be enough...


olly

[1] http://typo3.org/uploads/media/Inline_Relational_Record_Editing_01.pdf
-- 
Oliver Hader
TYPO3 4.3 Release Manager