I feel like this must be something that comes up all the time, but I can’t figure it out.
I’m making a database for my choir and we are looking for a way of tracking which people sing which parts in each individual song we have in our repetoire. People often know multiple parts and we need to be able to track that.
I’ve got these tables
- Choir Members
- Songs (all parts listed in multiselect field)
- Which parts in which songs
What I want is to be able to send out a form to call choir members asking them to select what parts they can sing in each song, taking the multiselect from the ‘Songs’ table.
Currently the Lookup field I have has just concatenated all the options into one field, which isn’t what I want.
Apologies if there are multiple answers to this question, but I couldn’t find anything similar. Maybe I’m approaching it the wrong way?