I am having a hard time in trying to realize the following idea:
- Have a List of People with Contact Details ( John, Tom, Mike )
- Have a List of Events with Dates ( Christmas, Easter, Thanksgiving )
No I would like to open the Event and select the people joining it ( best with checkboxes or a dropdown selection etc. ).
People <-> Events is a many to many relation.
I already introduced a helper sheet as combined reference named PeopleEvents.
( John | Christmas , John | Easter , Mike | Christmas )
But somehow I do not find a solution to open my event ( Christmas ) and select the participants from a List.
I thought probably someone can help?