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

Groups > comp.databases.filemaker > #3105

Re: Value List From a Field

Show all headers | View raw

On 2018-03-20 21:33:34 +0000, Charles H. Sampson said:

> Helpful Harry <HelpfulHarry@BusyWorking.com> wrote:
> 
>> On 2018-03-19 20:32:37 +0000, Charles H. Sampson said:
>>> 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.
>> 
>> You might want to take the space out: "OrchestraList"
>> 
>> The usually recommend approach is to prefix value list names with
>> something like "vl" ... vl_Orchestra" perhaps.
>> 
>> I'm not sure if "List" by itself is a reserved / special word, which
>> could (although shouldn't) cause problems.
> 
> If you use a word that's going to cause problems - I always want to use
> "and" - you get a warning about it.

There are some words which are fully prohibited and not usable at all, 
but there may be others which are even though they are allowed may not 
be wise to use, even just for the sake of readability.

Prefixing the names of things can make them easy to identify. For example,

    vl_    for Value Lists

    g_     for Global Fields
    (or "g_con_" a Global Container Field and "g_txt_" for a Global Text Field)

    rel_   for Relationships

Similarly for not including spaces in names. Something like "My Value 
List" may be easily misread in the depths of a complex formula, but 
"My_Value_List is more easily identifiable as not being a Script 
command or function name.

It does of course get even messier if you could use things like "Fred 
and Bert" or "Fred + Bert" ... is that one Field name or is it two 
Fields and a function??

Helpful Harry   ;o)

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