Groups | Search | Server Info | Login | Register

Groups > comp.databases.filemaker > #3535

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

Show all headers | View raw

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.

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.



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

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

That seems to be saying the State field is getting its value list data 
from the same field (i.e. People table), but the state value list needs 
to get its values from the Cities table rather than the People table.

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.


Helpful Harry  :o)

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