I once used this cool trick I got from Filemaker advisor but I can't
remember it anymore.
What I want to do is sort my list of items by a "room" field (kitchen ,

bedroom, bathroom , etc). When the list diplays (in a portal) I don't
the items to all have the room name beside them, just the first one the

the following ones are blank .


example
Room item
Kitchen Mixer
Microwave
blender
Bedroom Clock radio
filing cabinet
Bathroom Razor


The trick involved lookups and some sort of self join so that only the
first occurance shows ......anyone know this one?