whizzkid

whizzkid Jul 1, 3:56 pm show options

Newsgroups: comp.databases.filemaker
From: "whizzkid" <wccgr...@mts.net> - Find messages by this author
Date: 1 Jul 2005 08:56:02 -0700
Local: Fri,Jul 1 2005 3:56 pm
Subject: lookup trick
Reply | Reply to Author | Forward | Print | Individual Message | Show
original | Remove | Report Abuse

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?