3 Replies Latest reply on Sep 27, 2011 11:11 AM by philmodjunk

    Address label solutions from contacts



      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:

      1. 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.

      2. 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?


        • 1. Re: Address label solutions from contacts

          You need a join table between students and Parent tables:


          Students::StudentID = Student_Parent::StudentID
          Parents::ParentID = Student_Parent::ParentID

          This way, you have exactly one record for each parent (or household as is more accurate), one record for each stucent and then a join table links a given student to the appropriate list of Parent records. (It's not impossible for a student to have more than two such contact records...)

          On a students layout, a portal to Student_Parent can list all parent contact records with any additional fields needed from Parents added inside the portal row. On a parents layout, this method can be reversed to list all students for that Parent.

          You'd then print labels from the Parents layout and avoid duplication and be able to print more than one parent address label.

          This is called a many to many relationship. Here's a demo file that illustrates this method by matching "contracts" to "companies" in a many to many relationship:  http://www.4shared.com/file/PLhjErzu/Contracts_to_Companies.html

          • 2. Re: Address label solutions from contacts

            Thanks for your quick response.

            In addition to the Parents table, I also have two further tables for Email addresses and Telephone Numbers. How can I incorporate these into the Student/Parent setup?

            • 3. Re: Address label solutions from contacts

              If they are email addresses and telephone numbers for parents, I'd link them to the parents table. If they are data specific to a given student, I'd use a link to the students table.

              You may even want to use the same data source table for both parents and students since the contact info would be of the same basic nature.