Groups | Search | Server Info | Login | Register


Groups > comp.databases.filemaker > #408

Re: Alphabetic pick list using self join and portal

From cortical <cb@corticaldata.com.au>
Newsgroups comp.databases.filemaker
Subject Re: Alphabetic pick list using self join and portal
Date 2011-10-01 09:22 +0930
Organization Aioe.org NNTP Server
Message-ID <j65knm$ht0$1@speranza.aioe.org> (permalink)
References <26011292-cb44-4d61-a551-ac311e2a5103@m5g2000vbe.googlegroups.com>

Show all headers | View raw


On 26/09/11 10:13 AM, Katie Blake wrote:


now that you appear to have it working; another option is to do away 
with the aec, and use a global + filtered rel, so you can morph it into 
a clairvoyant search


have the same ABC buttons script the letter into a global g_search

create a calc c_search = g_search + "zzz"

redefine the self rel to be multi-parameter:

g_search ≤ name
c_search ≥ name

the portal result will initially be the same, but now you can refine the 
result by typing in the global

With some more advanced scripting and script triggers, the result can be 
made to refresh with each keystroke in the global

Back to comp.databases.filemaker | Previous | NextPrevious in thread | Find similar


Thread

Alphabetic pick list using self join and portal Katie Blake <kathlynblake@gmail.com> - 2011-09-25 17:43 -0700
  Re: Alphabetic pick list using self join and portal Martin Τrautmann <t-usenet@gmx.net> - 2011-09-26 04:45 +0000
  Re: Alphabetic pick list using self join and portal yourname@yourisp.com (Your Name) - 2011-09-26 18:33 +1200
    Re: Alphabetic pick list using self join and portal Martin Τrautmann <t-usenet@gmx.net> - 2011-09-26 06:43 +0000
      Re: Alphabetic pick list using self join and portal yourname@yourisp.com (Your Name) - 2011-09-27 09:07 +1200
        Re: Alphabetic pick list using self join and portal Katie Blake <kathlynblake@gmail.com> - 2011-09-28 01:03 -0700
  Re: Alphabetic pick list using self join and portal Martin Τrautmann <t-usenet@gmx.net> - 2011-09-26 06:51 +0000
    Re: Alphabetic pick list using self join and portal Katie Blake <kathlynblake@gmail.com> - 2011-09-26 00:41 -0700
      Re: Alphabetic pick list using self join and portal Martin Τrautmann <t-usenet@gmx.net> - 2011-09-26 08:40 +0000
  Re: Alphabetic pick list using self join and portal cortical <cb@corticaldata.com.au> - 2011-10-01 09:22 +0930

csiph-web