Need help with views

We encourage users to post events happening in the community to the community events group on https://www.drupal.org.
ratnesh aarohi's picture

I think my need is simple but after a whole lot of search i am unable to get it working - hence this post

i have one cck (*called movies_db) with movie_name (node title), movie_director, Movie_number, Movie_actor, Movie_Actress, movie_rating, etc ( few more fields);

Next i have another cck called Movieshow_schedule with two fields - one date and another (a node reference) to the above movie_name.

Now I want a view which shows the movie show schedule (based on node: 'movieshow_schedule') which lists, in tabular form
1. the date and with the date
2. lists its referred movie_name
AND ALSO the relevant
3. movie_rating and
4. movie_actor and
5. movie_actress
(only the above fields)

Through node reference i got the movie name to show up in the view next to the relevant date (comes with as a link).
but I am not able to get the selected fields (about the movie) to get listed next to date and movie_name

So, How do i get only the selected fields from the referred node to show up in views in tabular form. (realise i don't want to show all the fields from the movie_name cck)?

thanks
ratnesh