I have two content types: Article and Magazine. in Article there's an entity reference field to Magazine, field_related_magazines.
On my website, when an article is shown, I would like to show a list of related articles that share the same magazine.
When I make a new article, I can choose the magazine edition in which the article appeared. Then, on the bottom of the node page, all other articles should be listed.
The thing I tried:
Make a views block 'Magazine related items' that lists Article titles and place the block on the Article pages.
Set the context for the block to work: Advanced>Contextual Filters>Content ID>Provide default value>Content ID from URL
Set the relation: relationships>Content using field_related_magazines (relate each Content with a field_related_magazines set to the content item.)
However, this only shows the current articles' title, not the titles of all other articles that share the same magazine. How would I get all the others?