You need to sign in to do that
Don't have an account?

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