Hi!
How I can add related campaign to account form?
In general I have two N:N relation:
Accont- Marketing List
Marketing List - Campaign
But, of course, I can't add related table (Campaign) on Account form...
*This post is locked for comments
Yvan, if you take a look at the post I inked above from Hosk he explains how to do this!
Anatoli, can you post your steps if you managed to achieve this?
Thanks!
Any second level relationship you can get using fetch xml and bind it to grid on main form where you wish to display. There is no OOB feature to show.
Yeh this is a limitation you cannot access second level relationships from the parent relationship.
Personally I would use the "FetchXMLBuilder" tool from MSCRMToolKit or download fetch query from advanced find if its a simple query. Then using JavaScript inject the fetchxml into the subgrid view on the form. A quick google shows this old post from Hosk who is doing something similar in his example.
Another option could be to have a hidden lookup to the account on the campaign which is set automatically when the marketing list is chosen and then you can use this relationship for the subgrid.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,240 Super User 2024 Season 2
Martin Dráb 230,149 Most Valuable Professional
nmaenpaa 101,156