Duplicate record shows only one

[Anh_Tran]

Hi All,

I have a simple question which i still don't get it.

I have several duplicate records and single record but what i want is to show only one time . I used self-relationship and status(recordnumber) but it does not work.

let's say i have

file and name:

dd123 Bill

dd124 Goerge

dd123 Bill

what i want to see is ...

dd123 Bill

dd124 goerge

is there a way to do so ...i know someone has a trick on it . But i use recordnumber but it gives many dupolicate of 1 and 2 and so on. That is why it does not work. Can portal show only one time?

Someone can help. I really appreciate it.

Thanks

Anh Tran

[QuinTech]

Hi Anh, i'm not exactly sure what you're asking, but i think you may be able to achieve this with sub-summaries (at least for printing/preview purposes).

Add two sub-summaries to the layout, the top one a sub-summary sorted by FileName, the next sorted by Name. Put both your fields in the sub-summary by Name part, go to preview mode, sort by FileName then Name, and maybe you'll see what you're looking for.

Jerry

[andygaunt]

Hi -

If you want to do this on a portal, you can find an example at http://www.fusiondezign.com/downloads/downloads.htm called Find Duplicates.

Quintech is right that you can use subsummaries to view in preview mode the single version of a name. Also useful for de-duplicating a database is to use this sub-summary method and then export your data with the option summarize by checked. When done on a layout with subsummaries enables you to filter the export.

HTH

[-Queue-]

You asked a similar question a while back here. I would say to do the same thing again.

[Anh_Tran]

Thanks All

I kind of getting it.

Anh Tran