I have created a Student Database that tracks information on students and their parents. I want to send an email to the parents using "Go to Related" records from the Student table to the Parents table. Because there are siblings in the student table, thus creating "mom and dad" twice in the Parents table, it shows me the mom and dad twice in the parents table when using this script. I only want to send each parent the email once.
I have figured out how to create a field that flags each parent as unique using "1" so I'm set there. My problem now is going to the related records and only showing each parent once.
What is the best way to omit duplicate parents once I have used the "Go to Related Records" script?
Thanks for your help!