Hi,
Here is a scenario: I have a custom entity called "Event Subscription". It's an intersecting entity between "Contacts" and "Events" (So instead of an N:N relationship, both have a 1:N relationship to "Event Subscription"). I want to see if an "Opportunity" or multiple Opportunities came from each "Event Subscription", and I want to be able to chart the Opportunities that came from the "Event Subscriptions" to see which were most effective.
At first glance I would assume I would need to create a 1:N relationship between the entities "Opportunity" and Event Subscription". However, whilst this allows me to list the Opportunities on the Event Subscription form using a Sub-Grid, it doesn't allow me to chart when viewing all Event Subscriptions because I have no field to reference in the chart pane.
I've thought about then creating a 1:N relationship the other way as well. This works with an Opportunity lookup field being placed on the Event Subscription form and allows me to create a chart; however, it only holds one opportunity. The Sub-Grid was able to show multiple opportunities stemming from the Event Subscription.
Any Ideas?
*This post is locked for comments
I have the same question (0)
