Hi All,
Still a newer user here. I am trying to bring Contact Information into a DDP from SFDC. The test to bring back the specific contact I need is that the Opportunity Record will list the desired contact by Full Name only via a dropdown Menu. The options within the dropdown are controlled via a Checkbox on the Contact Record itself. I have tried several SOQL expressions below is the one I thought had the most potential. Any help would be appreciated.
Fields used
xBContact (SOQL Alias)
Bill_To_Name__c (Full name on the Opportunity of the person I want to bring back)
Name, Title, Phone, Email, MailingAddress (From Contact Record)
Expression
xBContact
SELECT Name, Title, Phone, Email, MailingAddress FROM Contact WHERE Bill_To_Name__c = '<<Name>>'