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

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

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....

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.