title: Show Related Fields in View
body: <p>Within a Dynamics 365 setup, I have 3 entities related like this:</p>
  
  <p><code>Quotes &gt;0----|| Counterparties ||----0&lt; Facilities</code>
  and
  <code>Quotes &gt;0----|&lt; Facilities</code></p>
  
  <p>In text, Quotes has a N:1 relationship with Counterparties and a N:N relationship with Facilities. Counterparties has a 1:N relationship with facilities.</p>
  
  <p>I am trying to construct a view that might look like this:</p>
  
  <p><code>Quote Date | Quote $ | Counterparty Name | Facility Address
  2018-01-15  | 500.25  | ABC Company       | 123 Main St
  2018-01-15  | 500.25  | ABC Company       | 200 Main St
  2018-02-28  |  79.30  | Different Co      | 5 N Pole Dr
  2018-05-05  | 902.99  | Third Inc         | 654 Accent St
  2018-05-05  | 902.99  | Third Inc         | 655 Accent St
  2018-05-05  | 902.99  | Third Inc         | 656 Accent St
  2018-05-05  | 902.99  | Third Inc         | 657 Accent St</code></p>
  
  <p>When I start the view on the entities:</p>
  
  <ul>
  <li>Counterparty entity view can't reference data from either Quotes or Facilities</li>
  <li>Quotes entity view can reference Counterparty but not Facilities</li>
  <li>Facilities entity view can reference Counterparty but not Quotes</li>
  </ul>
  
  <p>Is there a way I can obtain all 3 in one view?</p>
  
  <p>Context: We are migrating from an onsite Dynamics installation to online Dynamics 365. A view like this was previously used to feed several business processes, except it's data source was the underlying database behind the onsite installation.</p>
  
  <p>EDIT: the equivalent SQL code would be this. The where clauses change by use, but I'm just trying to create the master list to filter later:
  <code>
  select quote.date, quote.amount, counterparty.name, facility.address 
  from  quote inner join counterparty on quote.counterparty_id = counterparty.id 
              inner join facility on facility.counterparty_id = counterparty.id</code></p>