This short guide is a how-to on displaying one content type associated to another content type using Entity Reference and Views.
Example Use Case
We have two content types, one is Club, the other is Club Agenda.
A club node contains the details of the club - such as location and time of the club regularly meets, plus maybe a short description. Changes made to a club node are rare.
However, a club agenda node will change for each meeting. So in this use case, it makes sense to use an Entity Reference field in the club agenda content type in order to associate a club node to a club agenda node.
The end result we're going for in this use case is to display a link to the latest agenda on a club's page.
Set up the content types
Hopefully, you are already familiar with how Content Types work in Drupal. If you're not, then please head on over to http://drupal.org/documentation/modules/field-ui for a detailed guide.
Club Content Type
Club Agenda Content Type
Set up the view
Go to Administration > Structure > Views > Add a New View. Make sure to uncheck "Create a page" and check "Create a block". Included is a screenshot of what the process looks like before clicking "Continue & edit". Also, make sure that the content type is the one that has the entity reference field and not the other way around.
Add a relationship
After clicking "Continue & edit", you'll be taken to the View display. In the third column (farthest to the right), click "Advanced". Click the "Add" button to the right of Relationships. Find the "Entity Reference: Referenced Entity" relationship and check the box. Click "Apply". On the next screen, click "Apply" right away unless you want to change the identifier or make the relationship required.
Add a contextual filter
Click the "Add" button to the right of Contextual filter and select "Content: Nid".
Under "Relationship", ensure that the entity reference relationship you added previously is selected. Next, select "Provide default value" and then set the type to "Content ID from URL". Click "Apply".
Unless you would like to adjust the fields or add other items to the view, go ahead and save the view.
Adding the block
In order for the view block to show up, you will need to go to Administration > Structure > Block and find the View block you just created. Place it into the region you would like for it to show up in when a club node is accessed. This will most likely be the Content region. Navigate to one of your club nodes that you have referenced in an agenda node. It should now display a link to the agenda!