RE: Charts with data from two different entities with one to many relationship
[quote][/quote]
Hi kale99,
According to my understanding of your content, if the relationship of two entities is 1:N, so why can't each participant take part in different engagements?
In my opinion, one Engagement may contain many Participants as you mentioned, but one Participant could also participate in many Engagements, the relationship of the entities should be N:N.
If so, you need to create a new filed on Participants form and manually count the number of participants' participation.
If my understanding is wrong, please kindly share more information to explain your requirements.
Hope it helps.
Best Regards
Leo
Hey LeoAlt,
You are absolutely correct. the relationship is a N:N. i created an N:N relationship between the two entities ( Participants and Engagements ). should i remove the 1:N relationships that currently exist in this case ?
is the correct way create the field in the form using subgrid views ? that seems to be the only way that i could add a participant to an engagement and see all the participants listed there and the same with engagements.
there is no engagement entity in the set of fields available when trying to create the new count field. Any suggestions ?
Thanks for the help
Share
Report
All responses (
Answers (
55,410
