Groups | Search | Server Info | Login | Register

Groups > comp.databases.filemaker > #400

Re: Alphabetic pick list using self join and portal

Show all headers | View raw

On Sun, 25 Sep 2011 17:43:30 -0700 (PDT), Katie Blake wrote:
>  I have then created a layout with three elements:
> 
>  a)  A portal from the self-join relationship (TestSelfJoin 2) In that
>  portal are two fields from TestSelfJoin 2) - name, and Calc.
> 
>  b)  A field for Filter from TestSelfJoin (the original table)
>  formatted as a series of radio buttons down the screen using the
>  alphabet value list, so you can see a long list of single letters.
> 
>  c)   Fields from TestSelf Join for single records.

So when you click the radio button, this field does get the value of a
single letter. Did you verify that this does actually happen? Place this
field without button formatting once again on the layout and look at its
content. 

I'll call this field "index" - and, btw, later versions of FMP
do permit to make this field for global storage, while still permitting
to use it within relationships.

>  What I had hoped would happen is that as I clicked a letter of the
>  alphabet in the Filter (TestSelfJoin) field at a), the portal from
>  TestSelfJoin 2 at b) would populate with Names beginning ONLY with
>  that letter of the alphabet.  I could then do a script which would Go
>  to Related Record and that would display  in c)

When you click "index", and when you have a relationship "TestSelfJoin
2" from "index" to "leftname1", you actually should see the related
records
 
>  It doesn't. 

So I guess your relationships are not clean, e.g. by taking the proper
relationship for the portal, but not for the related fields within the
portal.

>  The portal continues to display the complete list of
>  names in TestSelfJoin. 

Hm, wild guess: even for names beginning with T or F?
What's the result of left(name,1) - is it defined as number instead of
text?

- Martin

Back to comp.databases.filemaker | Previous | Next — Previous in thread | Next 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