Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.filemaker > #3094

Re: Value List From a Field

Show all headers | View raw

Martin ?rautmann <t-usenet@gmx.net> wrote:

> On Sun, 18 Mar 2018 16:39:33 -0700, Charles H. Sampson wrote:
> > I'm back for my latest public tutorial on how to use FileMaker. I'm not
> > sure how to describe what's going wrong, so I'll start with what I'm
> > trying to do.
> >
> > Conceptually, I want to create a list of values in a "file". I write
> > "file" because I don't really want to use an external file, I want to
> > use a table in my database. So I create such a table (call it "the value
> > table") and populate it with a few values. I also create a value list
> > (call it "the value list") whose values come from a field in that table.
> > Then I create a field (call it "the value field") in another table that
> > is going to get its values from the value table. On a layout that has
> > the value field, I set things up using the Inspector so the value field
> > gets its values from the value list as a drop-down list. At least, I
> > think that's what I've done.
> 
> Which name did you give to your value list?

I'll get specific instead of writing generally. The table is named
Orchestras. The list is name Orchestra List.

> > It doesn't work. To begin with, when I click in the field that is
> > supposed to be a drop-down list, I get a protest that the value table is
> > an unrelated table.
> 
> It works. I just created a dummy file which works just perfectly. I'll
> send it over to you.

How? Do you remember that I once set up Drop Box? It was so long ago
that I've forgotten how to use it.

Charlie
-- 
Nobody in this country got rich on his own.  You built a factory--good.
But you moved your goods on roads we all paid for.  You hired workers we
all paid to educate. So keep a big hunk of the money from your factory.
But take a hunk and pay it forward.  Elizabeth Warren (paraphrased)

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

Thread

Value List From a Field csampson@inetworld.net (Charles H. Sampson) - 2018-03-18 16:39 -0700
  Re: Value List From a Field Helpful Harry <HelpfulHarry@BusyWorking.com> - 2018-03-19 13:41 +1300
    Re: Value List From a Field csampson@inetworld.net (Charles H. Sampson) - 2018-03-19 13:27 -0700
      Re: Value List From a Field Helpful Harry <HelpfulHarry@BusyWorking.com> - 2018-03-20 10:12 +1300
        Re: Value List From a Field csampson@inetworld.net (Charles H. Sampson) - 2018-03-22 13:57 -0700
      Re: Value List From a Field Howard Schlossberg <howard@nospam.fmprosolutions.com> - 2018-03-20 14:46 -0700
  Re: Value List From a Field Martin Τrautmann <t-usenet@gmx.net> - 2018-03-19 06:32 +0000
    Re: Value List From a Field csampson@inetworld.net (Charles H. Sampson) - 2018-03-19 13:32 -0700
      Re: Value List From a Field Martin Τrautmann <t-usenet@gmx.net> - 2018-03-19 21:01 +0000
        Re: Value List From a Field csampson@inetworld.net (Charles H. Sampson) - 2018-03-20 14:33 -0700
          Re: Value List From a Field Martin Τrautmann <t-usenet@gmx.net> - 2018-03-21 06:38 +0000
      Re: Value List From a Field Helpful Harry <HelpfulHarry@BusyWorking.com> - 2018-03-20 10:15 +1300
        Re: Value List From a Field csampson@inetworld.net (Charles H. Sampson) - 2018-03-20 14:33 -0700
          Re: Value List From a Field Helpful Harry <HelpfulHarry@BusyWorking.com> - 2018-03-21 14:07 +1300

csiph-web