Groups | Search | Server Info | Login | Register

Groups > comp.databases.filemaker > #399

Alphabetic pick list using self join and portal

Show all headers | View raw

What on earth am I doing wrong?  Thanks to various posts here over the
years, I have been experimenting with using a self-join to populate a
portal with ONLY contact names starting with a specific letter.  This
is what I have done:

Designed a new database with only one table, and three fields - Name,
Calc, and Filter.

Name is a text field with surnames
Calc is a global field which calculates the first letter of each name
using Left (Name ; 1)  This works perfectly
Filter is a text field which uses a value list of each letter of the
alphabet.

There is a self-join between Filter and Calc, with Filter = Calc  (so
Filter is on the left side, and Calc is on the right looking at the
screen defining the relationship.  The two tables are TestSelfJoin,
and TestSelfJoin 2.

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.

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)

It doesn't.  The portal continues to display the complete list of
names in TestSelfJoin.  How can I get it to display only names
beginning with the (correct) filter character?

Any help gratefully received, as I struggle to understand how self-
joins work.

Katie.

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