Address label solutions from contacts
I am looking for a solution for printing parent/guardian address labels from my student database.
I have one record per student. Each student has a related table containing Emergency Contact #1 and a separate related table containing Emergency Contact #2.
I currently print address labels of contacts in the Emergency Contact #1 table, as these are generally the primary parent/guardian contact for each student. This works well except for 2 issues:
- Some students are siblings, therefore there are duplicate entries in the contacts table, as they obviously have the same parents. I would like to avoid these duplications.
- A few student's need things posting to more than one parent – ie, mother & father who live at different addresses. Mother, for example, is Contact #1 and is in the address label printed set, Father is Contact #2 and isn't in the printed set so I have to run off a separate printed label.
Can anyone suggest a setup that will get around these two issues?