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-17 09:16 +0200
Organization	slrn user
Message-ID	<slrnugd9tl.rce.t-usenet@ID-685.user.individual.de> (permalink)
References	<slrnug0o5n.rce.t-usenet@ID-685.user.individual.de> <slrnugaqei.rce.t-usenet@ID-685.user.individual.de> <ue58da$q5l$1@dont-email.me>

Show all headers | View raw

On Sun, 17 Sep 2023 09:58:02 +1200, Helpful Harry wrote:
>>> 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
>>     ...
>
> I haven't tested it, but if the value list was just getting values 
> directly from the field, you'd probably get one entry from each 
> separate People table records.
>
> But since the value list is getting it's values via a relationship link 
> to the field, you'll get an increasing number of values as each 
> spearate People table record finds more and more related records as new 
> records are added.

I disagree. Why would there be any benefit in order to show the same
value multiple times - especially if it is not a 1:1 number of
repetitions, that you will have exactly the same number of matching
entries?

> That makes it difficult for users to enter a new City because it 
> doesn't have a previous existing record - value lists from fields can't 
> be edited like normal static lists can.

A drop down list is a suggestion only. You still can edit other values
here, although those values shall not become part of the drop down
suggestions. Usually this would be villages which muss less importance.

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