In Drupal 7, what are the best ways of creating relations between nodes?
Say I have a number of articles about famous writers. I want to build an alphabetical list of them using Views. As writers often have pseudonyms, I want these pseudonyms to appear in the list too but creating a node for a pseudonym that is identical to its respective Writer node in all aspects except title sounds like not quite good idea.
I thought a bit and came up with 2 node types, Writer and Writer_Pseudonym:
Writer
- Title
- Body
- All other fields
Writer_Pseudonym
- Title
- Target Node Id
Now I want to build a view in which nodes of type Writer_Pseudonym will display body text of their target nodes:
Title: Doe, John (Writer)
Body: John Doe, also known as Evil John, is a writer that became famous after creating an autobiographical novel "Foobar".
Title: Evil John (Writer_Pseudonym)
Body: John Doe, also known as Evil John, is a writer that became famous after creating an autobiographical novel "Foobar".
Is it possible to do it with Views? And if not, are there any other ways to establish relations between nodes while being able to use fields of target nodes?