Generate a Letter Using Opportunity & Opportunity Contact Role

  • 19 January 2021
  • 1 reply
  • 17 views

We are trying to create a letter that pulls fields from an Opportunity as well as the Account record of the Contact of the Opportunity Contact Role.

Got that? So...

Opportunity (need fields here) > OCR > Contact > Account (need fields here as well)

 

I can get from Opportunity to the OCR Contact record, but not to that Contact's Account record. I got to the Contact record by starting with Opportunity and adding OCR as a Child relationship (Lookup is not an option). But I can't get from the OCR's Contact record to that Contact's Account.

Any ideas? Thanks!


1 reply

Userlevel 5
Badge +13

I would suggest trying a SOQL query for this one(https://help.nintex.com/en-US/docgensf/DeliveryStorage/SOQLQueryRelationships.htm).

Reply