List layout without duplicates

[Symont]

Hi, I'd like to do a list layout, but I don't want to see duplicates of the same content; although I want to see the first occurence of the duplicates.

A little bit a detail will help understand. I have DB of different people living in different towns. Each town as a seperate related record in another table (one name can have more than one town but each records in the Town Table as only one of each; so the same person has more than one record in the Town table and the same town can repeat with different people - is it clear??). I'd like to do a layout (list mode) so I could have something like an index of the towns in the Town table. My problem is that I don't want to see each town more than once. Is there a way to do this (maybe a script that omits repetitions? In that case, if a town has more than one occurence, it's not shown at all) or is there a better and simpler way to create indexes that the users can use?

Thanks

[Vaughan]

Search the forums for "omit duplicates" there are heaps of posts about this. It seems to come up every other day.

[Symont]

The thing is I don't want to omit duplicates, I want to keep the first occurence and then omit the rest. I took a look and didn't see anything....

[-Queue-]

Those are two ways of saying the same thing (omit duplicates and keep originals). Another is to say find a distinct set of records. Do a search for any of these key terms, and make sure to remove the 1 from the date range field.