lookup trick - 07-01-2005 , 10:56 AM
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 .
Bedroom Clock radio
The trick involved lookups and some sort of self join so that only the
first occurance shows ......anyone know this one?