I have a scenario where I have to roll up the count of active campaigns that a contact is enrolled in.
To achieve this, I tried to create a master-detail on the Campaign Member to the contact. But I am not able to find this data type option when creating a new field.
I first assumed its because of existing data. But then I deleted all the data in Dev Sandbox and I still don't see the option.
What am I missing in this scenario? Is it not possible to create a Master-Detail for Standard objects?
Thanks in advance.