I am building out a dashboard to monitor campaign activities and I can’t figure out how to connect the CRCampaign and CRActivity tables. The CRActivity table doesn’t have the CampaignID as a field. It does show the campaign, but not as expected [CampaignID, CampaignDesc].
Any thoughts on how to pull this off would be appreciated!
Best answer by Gabriel Michaud
Hi Ehren,
You can join the CRActivity table with CRCampaign by using CRActivity.RefNoteID=CRCampaign.NoteID -- this will give you access to all the fields in the campaign table.
Gabriel
+11Hi Ehren,
You can join the CRActivity table with CRCampaign by using CRActivity.RefNoteID=CRCampaign.NoteID -- this will give you access to all the fields in the campaign table.
Gabriel
Thank you Gabriel! Works great!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.