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

Path	csiph.com!news.mixmin.net!eternal-september.org!news.eternal-september.org!.POSTED!not-for-mail
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	Sat, 16 Sep 2023 10:39:46 +0200
Organization	slrn user
Lines	48
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>
Reply-To	traut@gmx.de
MIME-Version	1.0
Content-Type	text/plain; charset=utf-8
Content-Transfer-Encoding	8bit
Injection-Info	dont-email.me; posting-host="a8d3c80e422775862c98ee6505b1020d"; logging-data="3905970"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX19Rxgb6GGeB7UsQNMKQGday"
User-Agent	slrn/1.0.3 (Darwin)
Cancel-Lock	sha1:CmVTAqWTB/NAaQjThKDpf6XYHlo=
X-No-Archive	Yes
Xref	csiph.com comp.databases.filemaker:3536

Show key headers only | 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