Here is what i have done

I have created two CCK node types.
FIRST - called ACTIVITY - contains three fields - activity name, activity details and activity resources.

SECOND node type - called SESSIONS - contains three fields too - one of this field is common field with the ACTIVITY node - three fields are - teachers's name (users), date of activity and activity name (this is the common field). The users choose the vlaue of the common field from "list of ACTIVITY node titles"

what each teacher does here is schedule different activities on different dates of a month specific to their class.

Now what i want is students to be able to see their schedule for a month. So i want to create a view which
shows date, activity name, activity details and activity resources and all of this is filtered by the teacher's name depending upon which teacher the student belongs to.

Specifically i want to know how do i create a VIEW which (takes data from two nodes and shows based on a common field)
so it should show for a specific teacher - date, activity name, activity details and activity resources.

i am just a teacher - hence do not have any php knowledge - but my guess is that it can be done in drupal with VIEWS.

Any suggestions and guidance most appreciated.

ratnesh

Comments

sun’s picture

sun
Primary language German
Location Karlsruhe
commented
Status: Active » Closed (won't fix)

Sorry, unfortunately this support request is way too specific. Please have a look at the issue queue - Views maintainers are buried already. You might want to try to get further support at http://drupal.org/support. Additionally, the answer to your question might be covered in the handbooks at http://drupal.org/handbook/modules/views already.
If you were able to solve this issue on your own in the meantime, you might want to add the involved steps to this closed issue, so other users searching for a similar solution might find it.