CKK & views -> organising information

Sorry for the screwed up version, pressed 'post' instead of 'preview':
--------------
Hey there,

I'm sorry, but I'm not managing to do what I want to do. Maybe it's not possible, but before to resigning to that option I wanted to check :-)

It's qiute possible that what I'm trying to do is just not possible in Drupal, or that Drupal is absolutely not the tool for the job. Of course, in that case, I would be most grateful if somebody would let me know so that I can stop trying :-)

As background: I am trying out whether Drupal is useful for doing research. Literature reviews, in particular. I'm currently doing a review on studies on reasons for ecstasy use and related behaviours, and I'm extracted info from several articles.

So the situation is as follows:

• Studies have been conducted by one or several authors;
• in these studies, one or several behaviours are studied (for example, "trying out ecstasy", "using ecstasy more frequently" and "ceasing ecstasy use");
• for each behaviour, one or several reasons is reported;
• and for each reason, potentially a percentage is provided

For example: "65% of the participants indicated that they tried out ecstasy because they were curious as to the effects"

I have created these content types:

• 'Author', with one field:
  • the obligatory 'title' field', holding the Authors name
• 'Study', with four fields:
  • the obligatory 'title' field, holding the study's title
  • a node reference to one or more 'author' nodes
  • the year when the study was conducted (not relevant)
  • the abstract (not relevant)
• "Behaviour", with one field:
  • the obligatory 'title' field, holding the behaviour's name (e.g. "trying out ecstasy")
• 'Reason', with four fields:
  • The obligatory 'title' field, holding the reason itself (e.g., "curiosity")
  • a node reference to a "behaviour" node
  • a node reference to a "study" node
  • a text field for the percentage (I deliberately did not use a decimal or integer field)

My idea was to first enter all authors of the studies; then to enter all studies; and then to start entering reasons. Before creating any reason node, I of course have to create the corresponing behaviour node, unless it exists already of course.

My plan was to then make a view to show the reasons organised by behaviour, so that you could easily see all reasons that had been studied for a certain behaviour.

However, I don't seem to be able to manage to make this view. I have tried (see http://ecstasyresearch.eu/index.php?q=overview_of_reasons), but it's a bit of a mess. When I 'group' by the 'behaviour' field in the 'reason' node, it doesn't actually group. It just splits the table in seperate rows, headed by the behaviour addressed in each row.

Does anybody know whether I'm doing something wrong, or trying to achieve the impossible, or have missed a module, or . . . ?

Also, while we're at it, is it possible that when I create a 'reason' node, and I select a behaviour in the "behaviour" node reference field, this reason is automatically added to the relevant 'Behaviour' node? Some kind of reciprocal node referring? Or would I then have to use the 'pages that link here' module and enable the Search module?

I'm sorry if these are stupid questions . . . I tried to find answers online, but this problem doesn't seem to have come up yet . . .

Thanks in advance, kind regards,

Gjalt-Jorn