Hello,

I have a student database with three layouts (fall, spring and summer). I would like to print one mailing label for each enrolled student during that year but when I make a search for "active" students in each layout, I have many duplicates because many of the students are enrolled in more than one semester. How do I get rid of these duplicates? I appreciate your help. Thanks, Samuel

Edited July 25, 200817 yr by Guest

hi samuel,

you can check the link below to solve your problem

http://thefilemakerblog.blogspot.com/2008/07/pick-one-copy-of-duplicate-records.html

Layouts are just copies of a TO, unless you have separate TOs for each of these classifications, you should be able to find your duplicates using the Find in your field for !. In Find Mode, it is one of the options in the drop-down menu under the Symbols.

HTH

Lee

Thank you for your reply. Is there a script or a way to omit duplicates without deleting them? There are over 900 duplicate records. Thanks, Samuel

Take a look at Finding only one of each record when there are duplicates! by Ray Link

Edited July 26, 200817 yr by Guest

The real problem here is NOT how to omit the duplicates, but how not to have them in the first place.

You should have (at least) two tables: one for Students (where every student has ONE UNIQUE record), and a related table of Enrollments, where each record represents one student's enrollment in one semester.

Yes, thank you very much. this is very helpful. Thank you all for your help. Samuel

One other technique is to use a summary part for your label in place of the body part. That way even with duplicates in your found set, when you sort and then preview/print you'll only have one of each.

this is brilliant! I like your solution, thank you very much. Samuel