I understand that this may be out of scope for the intended purpose of phpList. Basically, I’ve been asked to create a newsletter that will be sent to a membership list; But the memberships are comprised of students and their parents/guardians. Easy enough- I created a new attribute of “Subscriber Type” that stores values “Student”, “Parent”, “Guardian”, “Volunteer”, and “Staff”. I think we will eventually use segmentation to send various types of newsletters based on the subscriber type.
However, I need some suggestions on how to best handle the relationship between two subscribers: In the database, we will have everyone’s email, but now we need to keep track of “Student” and, say, two other subscribers related to this student, his/her mother (has her own email) and his/her father (also with distinct email).
I suppose one way to handle this is to create the new attribute “Relationships” with a textarea and manually retype the names of the student’s parents (which are already registered in the database).
I wonder if there is a more efficient way to track the different relationships that may exist between two or more subscribers.