Show fields of content type B while keeping filter criteria as content type = A in view

Question

I am creating a website in drupal.

I have two content types first is Article and second is Author

Article contains following fields: Title, Body, Author-name, Language

Author has following fields: Name, Year, Info

Now In a view I want to show the Article name, its author-name and the year of that author!

How can I do this? Thanks

Answer 1

You need Entity Reference, In your Article content type, create the author field as an entity reference field and refer it to the Author content type. After that you can create a view and add a relationship of Entity Reference and you will get the related fields. For further read, refer here