Groups | Search | Server Info | Login | Register

Groups > comp.databases.filemaker > #3534

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

Show all headers | View raw

On Fri, 15 Sep 2023 18:02:35 +1200, Helpful Harry wrote:
> I'm not sure quite why you need to bother with "first fields" and 
> "secondary fields". That's probably part of the weirdness you're seeing.

I don't know how else to do it yet

> The usual option to have have a separate table, e.g. StatesCities, 
> which has two fields:
>
>     LookupState    Text
>
>     LookupCity     Text

check

> Into this table you can import the needed data from the text file in your link.
>
>
> Back in the People table you need a two user data enty fields:
>
>     UserState      Text
>     UserCity       Text

check

> Now you need a relationship link that connects the data entered in 
> UserState to the list of appropriate cities from the StatesCities table:
>
>     rel_LookupCity   People::UserState = StatesCities::LookupState

check
> You also need to create two value lists:
>
>     vl_StateList     values from field StatesCities::LookupState
>                      include all values
>
>     vl_CityList      values from field StatesCities::LookupCity
>                      include only related values from rel_LookupCity

Ah, that had been my mistake. I don't know why I went via secondary
fields, which I usually never do. 

I guess that I expected more problems to re-compute the value list every
time, but performance seems to be ok.

> Drop-down lists using the appropriate value list.
> i.e.
>     UserState    Drop-down list, values from vl_StateList
>
>     UserCity     Drop-down list, values from vl_CityList

check

> When the user clicks on the UserState field they get a list of all the 
> states (alphabetically sorted) to choose from. Once they select a 
> state, the UserCity field will have a list of only the appropriate 
> cities (alphabetically sorted) for that state.

nevertheless it was an interesting malbehavior (?) that I observed here,
taking the approach with secondary fields, but receiving multiple
repetetions of the city's name.

Would you like to see a sample database with that problem? I guess I did
not understand the usefullness of secondary fields yet.

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