I need to be able to filter a portal so that it doesn't display the same information twice from a single field in a list of records being displayed.

I have a portal that lists cities. If the city name has already appeared, then I don't want to display it twice.

I tried using an [FMP-if] statement, but I couldn't make it work...

Any ideas?

Thanks,

Tony

I do not know enough about your design, but couldn't you use value list? That is showing only single value from multiple records with same entry.

[ February 09, 2002, 03:47 PM: Message edited by: Anatoli ]

Hmmmmmm. I don't know your design (or design capabilities) either, but could you sort by cities such that the name of the city would be the first record to appear, and the rest of the field repititions contained the data pertinent to each city?

I realize that displaying portals is very limiting.