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?