Relationship: Do multiple node types need a common reference?

Modules stable version: CCK, Views, Views_Calc

Goal: Report totals for volunteer hours from several node types

Joe | yr_joined | total_training_hrs | total_volunteer_hrs
Moe | yr_joined | total_training_hrs | total_volunteer_hrs
Sue | yr_joined | total_training_hrs | total_volunteer_hrs

===================================

I am presently using a Page and the PHP_Filter to run the query and generate the page manually. After watching a video tutorial about Views Relationships I could see the possibility, but I couldn't make it work with my current fields.

===================================

All the id fields mentioned below are a user_ref; however, I named them differently to keep them in their own database table.

• content_type_member ---- field_member_id --- single node per user
• content_type_vol_hrs ---- field_vol_id --- multi nodes per user
• content_type_train_hrs -- field_trn_id --- multi nodes per user

===================================

I tried Nancy's Fishing Tournament example; however, the events are different for each User and there were too many variables needed to complete the calculations after each entry.

Is it possible to generate the data table as I need it using Views-Relationships?

If so, do I need a node_ref field to join them all to content_type_member -or- a new user_ref field that has the same field name in all three content_types?