HELP! with Views and relational data

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

Hi I am creating a site that has the following content types:

  • Organization (Usernode)
  • Program (define a program)
  • Attendance Tracking (track attendance for the program added above)

I would like to create an admin view that shows me all the details for either program or the attendance tracking with data from the usernode. For example

Program Name
Organization Name
Province
Country
Postal Code

I'm just wondering what is the best way to have the Program and Attendance tracking content types reference this data. Would I need to create fields that query the database separately to get them into the content type? I am currently using CCK. I would like for the user once logged in to not have to specify the node reference to each of the fields above. The references should be automatic since the usernode should contain the items I would like to build my admin view on.

Thanks, any help would be much appreciated.