I have created a Multiselect Lookup for Accounts inside a Custom Module 1 called Events
So 1 Event can have multiple Participations that relate Event with Account participating.
Inside participations i want to add a Multiselect Lookup Field in order to relate Contacts to this participation.
I see i can create Lookup Fields in this Relationship Record, but i'm not allowed to create another multiselect LookUp in this level.
Is there any possibility or recomendation for this?
My Goal is to have 1 participation per Account participating in the event. And this participation can have as many contacts as we need.
So 1 Event -> Many participations
Each Participation -> Many contacts