duplicate labels

[_samuel_]

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, 2008 by Guest

[Osman]

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

[Lee Smith]

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

[_samuel_]

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

[Lee Smith]

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

Edited July 26, 2008 by Guest

[comment]

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.

[_samuel_]

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

[Fitch]

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.

[_samuel_]

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