You will likely need a custom UI, but if you are using Drupal 6, you might have some luck using <a href="http://drupal.org/project/noderelationships">http://drupal.org/project/noderelationships</a><br><br><div class="gmail_quote">
On Mon, Aug 15, 2011 at 4:24 PM, Peter Keane <span dir="ltr"><<a href="mailto:pkeane@mail.utexas.edu">pkeane@mail.utexas.edu</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
Greetings -<br>
<br>
I am not exactly sure how to approach a particular data modeling task<br>
in Drupal. Although I am newcomer to Drupal, I have experience w/<br>
relational database modeling (part of my ramp-up w/ Drupal is figuring<br>
how to map Entity-Relational concepts to Drupal). I'm faced w/ this in<br>
a few places on my current project, but I will describe just one<br>
example (simplified for illustrative purposes):<br>
<br>
I have a "book" content type and I have a "fictional character"<br>
content type. I need to record the page number on which a particular<br>
character first appears in a book. Note that a character can appear<br>
in many books and that a book (typically) has many characters.<br>
<br>
I can acheive this with an "appearances" content type which had node<br>
reference fields for both "book" and "fictional character" and a field<br>
for page number.<br>
<br>
What I am unclear on is how best to present this to a user who is<br>
entering data. In my particular case, the "book" content type will be<br>
pre-populated. I'd like to have a form for creating a new character<br>
which includes a pull-down list of books. When a book is selected,<br>
another widget appears in which a page number appears. This "pair"<br>
of book & page needs to be repeatable, since a character may appear in<br>
many books.<br>
<br>
The trick here is to have a form for creating one content type<br>
"fictional character" that upon submission, created not only the<br>
"fictional character" instance, but the necessary "appearance"<br>
instances as well.<br>
<br>
Any ideas (even if only a pointer to a module that might get me<br>
started, similar examples, or documentation) would be greatly<br>
appreciated. If writing a custom module is necessary, that is<br>
something I can probably tackle (any tips re: apis & such in that case<br>
would be welcome).<br>
<br>
--Peter Keane<br>
<br>
Liberal Arts ITS<br>
The Univ. of Texas at Austin<br>
<font color="#888888">--<br>
[ Drupal support list | <a href="http://lists.drupal.org/" target="_blank">http://lists.drupal.org/</a> ]<br>
</font></blockquote></div><br>