CiviCRM Community Forums (archive)

Is there any way to combine multiple tables within a Drupal view? For example can I combine Contact info (First & Last Name) with related Contribution and Membership details?

Ok. I have created a View Type "User" in order to combine three main things:

1) Contact fields (First Name & Last Name)
2) All the Contributions made by that particular Contact
3) Some details like Start & Finish Date of the related Membership connected to that Contribution.

Really, the issue I can't see past is what View Type would I choose in order to have those 3 elements even available as choices? And once that's chosen I should see relevant useful Relationships within Views(?)

Thanks again for any help you can give.