function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
BARJRDBARJRD 

How to reference Parent Campaign

I am having problems referencing ParentId from Campaign via the API in an MS Access form.  In addition to the code below, I have also tried:

Campaign.Parent.Name
Campaign.ParentId__r.Name
Campaign.Parent
Campaign.ParentID
Campaign.ParentCampaign.Name
...plus many others :-(

 

sQuery = "select Campaign.Name, Campaign.ParentId.Name, Campaign.RegistrationLevel__c,Campaign.ParticipationLevel__c, Campaign.StartDate, Contact.Name, PrimaryRole__c, Status, PaymentStatus__c from campaignMember"
    
Set qr = g_sfApi.Query(sQuery, False)

 

 

 

 

Any suggestions?  The query works fine if I remove the reference to the parent.

Thanks,

Barb