self join trick

  • Follow


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?

0
Reply wccgrant (8) 7/6/2005 3:31:57 PM


0 Replies
204 Views

(page loaded in 0.026 seconds)

Similiar Articles:








7/16/2012 8:59:24 AM


Reply: