I have created a database of music students and my goal is to email students, and or parents from groups such as the Band and Choir. I'm not quite sure how to tackle this
Ideally, I would like to choose multiple groups such has "Band" and "Choir", and give me the option to send to...
Parents the student is living with and/or
Then show them in a portal.
The relationship between the students who live with their parents are their address.
Should I find the students and parents from the various tables and export/import them into a separate table to send the email?
I'm open to all suggestions to accomplish this.