Re: [FMP11] value lists and secondary fields - shows secondary value multiple times

From	Martin Τrautmann <t-usenet@gmx.net>
Newsgroups	comp.databases.filemaker
Subject	Re: [FMP11] value lists and secondary fields - shows secondary value multiple times
Date	2023-09-16 10:39 +0200
Organization	slrn user
Message-ID	<slrnugaqei.rce.t-usenet@ID-685.user.individual.de> (permalink)
References	<slrnug86c9.rce.t-usenet@ID-685.user.individual.de> <ue2o1e$3epl2$1@dont-email.me>

Show all headers | View raw

On Sat, 16 Sep 2023 11:06:23 +1200, Helpful Harry wrote:
> On 2023-09-15 08:44:37 +0000, Martin Τrautmann said:
>> 
>> I guess I did not understand the usefullness of secondary fields yet.
>
> The secondary field in the value list definition means the City 
> drop-down menu could show both the city and the state.
>
> For example, if the user enter the state as California, then the city 
> drop-down menu would display:
>    Azusa California
>    Bakersfield California
>    Baldwin Park California
>   etc.

No, not if you would show the second field only, which is one of the
options.

> For this database example it is basically pointless since they will all 
> be the same state anyway, but displaying such a combined list can 
> sometimes be useful.

It's probably for additional info, but selecting one of those will not
take the second value, but the first value, even if the first value is
hidden.

> I think part of the weirdness you were seeing is possibly also due to 
> this, unless I'm reading it wrong:

The weirdness is that there are multiple repetitions of the same values,
depending on how many records do contain this value, but not a 1:1
match. I'd have to run some checks, but it's about the square root of
records - so for 10 records of California, the dropdown list would offer

    Azusa
    Azusa
    Azusa
    Bakersfield
    Bakersfield
    Bakersfield
    ...

> If you get the value list from the People table, the drop-down list can 
> only show values that have previously been entered (again something 
> that is sometimes handy), but which would prove "difficult" if there 
> are no existing records since the list would be blank.

That had been the purpose here.

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

Thread

[FMP11] value lists and secondary fields - shows secondary value multiple times Martin Τrautmann <t-usenet@gmx.net> - 2023-09-12 14:59 +0200
  Re: [FMP11] value lists and secondary fields - shows secondary value multiple times Helpful Harry <HelpfulHarry@BusyWorking.com> - 2023-09-15 18:02 +1200
    Re: [FMP11] value lists and secondary fields - shows secondary value multiple times Martin Τrautmann <t-usenet@gmx.net> - 2023-09-15 10:44 +0200
      Re: [FMP11] value lists and secondary fields - shows secondary value multiple times Helpful Harry <HelpfulHarry@BusyWorking.com> - 2023-09-16 11:06 +1200
        Re: [FMP11] value lists and secondary fields - shows secondary value multiple times Martin Τrautmann <t-usenet@gmx.net> - 2023-09-16 10:39 +0200
          Re: [FMP11] value lists and secondary fields - shows secondary value multiple times Helpful Harry <HelpfulHarry@BusyWorking.com> - 2023-09-17 09:58 +1200
            Re: [FMP11] value lists and secondary fields - shows secondary value multiple times Martin Τrautmann <t-usenet@gmx.net> - 2023-09-17 09:16 +0200
              Re: [FMP11] value lists and secondary fields - shows secondary value multiple times Helpful Harry <HelpfulHarry@BusyWorking.com> - 2023-09-18 10:28 +1200
    Re: [FMP11] value lists and secondary fields - shows secondary value multiple times Martin Τrautmann <t-usenet@gmx.net> - 2023-09-15 11:06 +0200

csiph-web