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

Groups > comp.databases.filemaker > #3089

Re: Value List From a Field

Show all headers | View raw

On 2018-03-18 23:39:33 +0000, Charles H. Sampson said:

> 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.
> 
> 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. In desperation, I create dummy link fields in the
> two tables, just so I can say that they are related. Now when I click in
> the field that is supposed to be a drop-down list, I no longer get the
> protest, but nothing happens at all.
> 
> Help?
> 
> Charlier

The word "file" may be confusing things.

   - In the "Edit Value List" window you should be using the
     option "Use values from field", and specify the field
     from your Value List Table.

   - Also check in the "Specify Fields for Value List" window
     that it is using the option "Include all values".

All done. Just set the data field format in the (horrible!) Inspector 
window to use this Value List.

You don't need a relationship link at all, unless you only want some of 
the Value Table data to be shown in the Value List.

Helpful Harry  :o)

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