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?

whizzkid wrote:

At this point, I would hazard a guess that nobody currently subscribed to
this group has the answer for you. The folks here are quite knowledgeable,
but that doesn't mean that they are aware of every trick ever devised. It
certainly isn't the only source of help.

I know, for instance, that you haven't tried the FMPExperts list at
http://www.ironclad.net.au/lists/FMPexperts/index.html. At least, I
haven't seen there any post similar to the four here.

There's a forum at http://www.clevelandconsulting.com/support/

and another at http://www.fmforums.com/

just to mention a few.

Matt

Sorry guys I didn't mean to sound snippy there. I just wasn't sure if
this was a dumb question or a tough question.
Allow me to clarify:

Each item in the file has two fields "Room name" and "item name"
ie:
Kitchen Mixer
Kitchen Blender
Kitchen Oven
Bathroom Shaver
Bathroom Scale
Bedroom Dresser

What I want it to show in a portal in a different file is:

Kitchen Mixer
Blender
Oven
Bathroom Shaver
Scale
Bedroom Dresser

As i remember it doesn't have to be in a portal, it shows that way in
the main file itself. But I could be wrong.

There is a self join trick or a lookup trick that uses thefact that
only the first occurance shows when you do it a certain way but I can't
remember it. I can do it through complicated scripting but I was hoping
that someone else knew this trick as it is a nicer way of doing it.

Thanks


Matt Wills wrote:

hey look at that...it works.....thank you very much
at first glance I still can't tell how it works though. I guess its cuz
in self joins it only puts the first occurance in the relationship

BUT....how do I handle updating it when records get deleted or added?
ie: if the item which is the first occurance of Kitchen gets deleted
how do I get the next in line to to "show" as kitchen?

Martin Trautmann wrote:

In article <1121212744.798972.30970 (AT) g43g2000cwa (DOT) googlegroups.com>,
wccgrant (AT) mts (DOT) net says...
When it self joins, all the occurences are in the relationship.. but the
first one is the only one that is ... first.

Whatever is first will be first, automatically