[TYPO3-irre] question about weak entities, foreign_table _field and edit direction 1:n

[Torsten Schrade]

Dear all,

while working my way into the brave new world of IRRE I came accross an
understanding issue of mine that i would like to ask the experts on this
list:

Let's say there are three main tables: sources, persons and places. Each
source record can relate to n persons and n places. I want to store
additional information on the relations using only one intermediate
table for all three tables.

Coming from the edit direction n:1 (places/persons > source) I can
define a "foreign_table_field" => "parenttable" in the TCA of
places/persons. When editors create a new relation from either table,
the name is inserted into the defined field in the intermediate table
creating a "weak entity". So later on it's possible to distinguish
between the relations. Everything perfect.

Now the question: I want my editors to create relations to persons and
places from within the source record, that is 1:n. In that direction I
would always need two intermediate tables, correct? foreign_table_field
is useless in this situation because coming from the 1:n direction the
parent table is always sources... Or can this be solved otherwise?

Any enlightenment highly appreciated. Cheers,
Torsten