Groups | Search | Server Info | Login | Register

Groups > comp.databases.filemaker > #3531

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

Show all headers | View raw

Hi all,

up to now I used scripted versions to set a mark flag on the fields that
I wanted to pop up in value lists.

But this time I tried once again to use popup values direcly and failed
miserably.

What I want to do is e.g. a "people" database with the fields "state"
and "city".

The state field is entered first, taking its values from the state field
itself (value list "state", from the entries of field "state").

City should be suggested, aaccording to the selected state.

Cities are within another table, taken e.g. from 
<https://gist.githubusercontent.com/Miserlou/11500b2345d3fe850c92/raw/e36859a9eef58c231865429ade1c142a2b75f16e/gistfile1.txt>

Relation "cities" is from people::state to cities::state

When I take people::town as the first field, cities::town as the second
field, that is
* first field: people::town
* secondary field: cities::town
* include only related values starting from "cities"
* show values only from second field

Oh use a drop down list, which looks best in table view (and behaves the
same in ther views), while a popup list works exactly the same.

That's the closest thing to what I need. But when I got e.g. 20 people
from California already, the value list repeats each of the cities 11
times. 9 people from Colarado, the value list shows each city 3 times.
So it's ok only if there's just one state entry, resulting in one
offerend city

It does not depend on the number of found records how many repetitions I
see, but the number of records that do contain a matching state field.


When I use different setups, 
* I do get e.g. all cities, once, but not filtered by state
* I do get all filtered cities, just once, but selecting one does
  not enter the selected city, but its state only

Where is my mistake, how would I do it properly?

Or is that a FMP11 but which was fixed later on?


Thanks
Martin

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