[TYPO3-irre] irre: record selector in 1:n relations
Oliver Hader
oh at inpublica.de
Mon Aug 13 11:17:01 CEST 2007
Hi Alex,
belbono schrieb:
> hi
>
> i´m developing an extension for my bachelor thesis and therefore i need
> to analyse every way of getting data into typo3.
Great. "Inline Relational Record Editing" was the topic of my diploma
thesis as well. What is the title of your thesis?
> according to the irre-tutorial extension i build up my tables and
> configuration. my extension will manage scientifical publications
> including some export funcionality.
> so i got a relation between a book and a publisher table.
> in my book table i have a publisher field that is configured as 'inline'
> and refers to the publisher table, by setting foreign_table,
> foreign_field and foreign_table_field, just as it is shown in the example.
> the problem now is, that i want to choose from existing records in
> publications. in m:n relations with an intermediate table you have a
> nice option with a record selector, but i think this is not possible in
> my 1:n relation. i only can add new publishers - what is quite
> unneccesary for a books released under the same publisher.
1:n relationships do not offer such behaviour in general. If you want to
relate one publisher to many books on the other hand, it's not a 1:n
anymore, but a m:n relationship.
> due to a record selector needs a configured select field on the other
> side (the foreign table), i tried to configure the uid field in my
> publisher table a such a field.
> so i got a selector field in my 'add book' dialog which shows every
> existing publisher, but i cannot choose anyone of them.
What happens if you select one of the records in the selector-box? Do
you get any errors (e.g. JavaScript errrors)?
> a solution of this might be to add another intermediate table, but i
> don't like this idea, because such a table unneccesary.
Why? Only the following model is necessary:
[book] --- 1:n ---> [intermediate table] <--- 1:n --- [publisher]
olly
--
Oliver Hader
http://inpublica.de/
More information about the TYPO3-project-irre
mailing list