multiple fields into one for eMail address list

[KarlaB]

I run a small fencing school. My little DB now has about 7 tables, with more than that replicated for setting relationships.

I have a contact table with a contactID (key) and e-mails, phones, etc.

I have a student table with various data. Each entry in the student table has the studentContactID of the student (the key), and up to two others -- one for parent1ContactID and another for parent2ContactID.

I have a ClassList table with records that contain a particularClassID, a studentContactID, and other information.

To obtain a list of students in a particular class, I simply find all entries from the ClassList table with a particularClassID.

I regularly need to send e-mails out to all students in a particular class, as well as their parents.

So, with my found set I can use related tables and export the e-mails from the contact table, using the studentContactID, parent1ContactID, and parent2ContactID.

So far, so easy.

There is no way to sort these on e-mail address, since I have up to three for each record. Moreover, the e-mail for the student is often the same as the e-mail for one (or both) of the parents.

To make things even worse, some parents are also students.

The objective is to get a list of unique e-mails so I can send out a class-related e-mail.

I like the summarize idea. Now, all I need to do is get all of the e-mail addresses into a single field. Right?

Thanks, so much.

Karla

[FM_SouthAfrica]

I have an email database of 14 0000 and I often need to check for 'duplicates' so I created a script which sorts by email address, runs from the top to bottom and flags the duplicates (i.e. marks a 'tag' field with a "Dup"), it even allows for tagging of MULTIPLE duplicates of the SAME email, PLUS when it encounters a duplicate it returns to mark the original with with a proverbial "Master" tag. After that it's easy to export a UNIQUE list

#_ Asks if U want 2 RESET only records which were previously marked or reset the ENTIRE database _

Show Custom Dialog

[ Title: "Message"; Message: "Do you want to Tag duplicate emails?

DupsScript.txt

[KarlaB]

Thanks.

[-Queue-]

You could also create a self-relationship based on email, and a calculation field of serial = self_email::serial. Then do a find for 1 in the calculation field to find only unique emails.