I'm currently using the following custom content types on my site: Account, Contact, and Location. The account type is the "parent object" and the location and contact types are the "child objects" of the account.
This relationship is setup in the following manner:
- Both the location and contact types have an entity reference field that points to an account type.
- Each account contains views (EVA Module) of referencing content (one for contacts and one for locations)
- Everything is streamlined by using the Entity Prepopulate module
While everything for the most part is working perfectly, I've run into problems when trying to use views.
As of now, I have a view that displays nodes in a table while restricting the content type to accounts. I'd like to display fields from the related location and contact types in this table; furthermore, I'd like to setup exposed filters to show only accounts that have a certain contact or location associated with them.
Seeing how the location and contact types point to the account and not the other way around, I can't seem to figure out how to do this. I believe this was solved in Drupal 6 using back references, however, I can't seem to find a current solution for Drupal 7.
Any and all help is appreciated.