I’m sure there is a simple solution, but I’m kind of stuck thinking through it.
We have a membership organization that hosts 3 to 4 workshops each year. Each of these workshops are made up of a team that runs the whole workshop. Each of those members during the workshop has a 3 important pieces of information: The workshop they are working, the role they are serving at the workshop, and if they present at the workshop the presentation they provided.
As you can imagine, a member can serve at multiple workshops throughout their years of membership in the organization but will have different roles and different presentations.
I want to be able to track at the Member’s record, the workshops they have served, the roles they served at that workshop, and the presentation they provided if they did at that workshop.
I’ve played around and have found multiple ways to do it in theory; but I’m concerned that I’m creating a bunch of data links and access data that is not really needed. Any simple solutions that folks may have or can suggest?