5 Replies Latest reply on Sep 10, 2012 1:33 PM by ronhofius

    VALUE LISTS NOT WORKING - when show values only from second field is selected

    richardwilton

      Summary

      VALUE LISTS NOT WORKING - when show values only from second field is selected

      Product

      FileMaker Pro

      Version

      12

      Operating system version

      windows 7 pro 64-bit

      Description of the issue

      when selecting show values only from second field is selected version 12 seems to ignore the basis of the first field that is selected

      Steps to reproduce the problem

      1) create file with 3 tables as follows:-
      STOCK, MEMORY, HDD
      2) STOCK Table to have following fields:-
      name - CODE, type -NUMBER, options - AUTO ENTER SERIAL NUMBER
      name - ACTIVE, type-number
      name - DESCRIPTION, type -TEXT
      name - DESCRIPTION LOOKUP, type-CALCULATION(text), options- indexed = if(ACTIVE=1;DESCRIPTION;""),evaluate even if all referenced fields are empty
      name - TEMP TEST FIELD, type -TEXT, options -GLOBAL
      3) MEMORY table to have following fields:-
      name - ID, type -NUMBER, options - AUTO ENTER SERIAL NUMBER
      name - STOCK CODE, type-number
      name - FULL DESCRIPTION, type -TEXT
      4) HDD table to have following fields:-
      name - ID, type -NUMBER, options - AUTO ENTER SERIAL NUMBER
      name - STOCK CODE, type-number
      name - FULL DESCRIPTION, type -TEXT
      5) Create relationship of = from table "STOCK" field "CODE" to table "MEMORY" field "STOCK CODE"
      6) Create relationship of = from table "STOCK" field "CODE" to table "HDD" field "STOCK CODE"
      7) create value lists as follows:-
      name - MEMWORKS use values from first field table MEMORY field STOCK CODE also display values from second field table STOCK field :DESCRIPTION LOOKUP include all values sort using first field
      name - HDDWORKS use values from first field table HDD field STOCK CODE also display values from second field table STOCK field :DESCRIPTION LOOKUP include all values sort using first field
      name - MEMFAULT use values from first field table MEMORY field STOCK CODE also display values from second field table STOCK field :DESCRIPTION LOOKUP include all values "show values only from second field"
      name - HDDFAULT use values from first field table HDD field STOCK CODE also display values from second field table STOCK field :DESCRIPTION LOOKUP include all values "show values only from second field"
      8)on layout for stock add following fields:-
      table STOCK fields CODE, ACTIVE,DESCRIPTION,DESCRIPTION LOOKUP ,TEMP TEST FIELD (3 times)
      9)assign value lists as follows:-
      MEMWORKS to TEMP TEST FIELD(1) as popup menu
      HDDWORKS to TEMP TEST FIELD(2) as popup menu
      MEMFAULT to TEMP TEST FIELD(3) as popup menu
      HDDFAULT to TEMP TEST FIELD(4) as popup menu
      10) add 12 records to STOCK table all set as active "1" with DESCRIPTION as "memory1","memory2","memory3","memory4","memory5","memory6","hdd1","hdd2","hdd3","hdd4","hdd5","hdd6"
      11) add 6 records to table MEMORY with:-
      STOCK CODE =1 DESCRIPTION=MEM1, STOCK CODE=2 DESCRIPTION=MEM2, STOCK CODE=3 DESCRIPTION=MEM3, STOCK CODE=4 DESCRIPTION=MEM4,STOCK CODE=5 DESCRIPTION=MEM5, STOCK CODE=6 DESCRIPTION=MEM6
      12) add 6 records to table HDD with:-
      STOCK CODE =7 DESCRIPTION=HARD1, STOCK CODE=8 DESCRIPTION=HARD2, STOCK CODE=9 DESCRIPTION=HARD3, STOCK CODE=10 DESCRIPTION=HARD4,STOCK CODE=11 DESCRIPTION=HARD5, STOCK CODE=12 DESCRIPTION=HARD6
      13)in any record of table stock on the layout select the various TEMP TEST FIELD fields to show results.

      Expected result

      TEST1
      when selecting the TEMP TEST FIELD's with the MEMWORK and HDDWORK value lists assigned the the popup menu should display the correct results of a list of values from the correct files where their ACTIVE status is 1. because they have been set to display both fields you should see a list as follows:-
      1 memory1
      2 memory2 etc
      and
      7 hdd1
      8 hdd2 etc

      TEST2
      when selecting the TEMP TEST FIELD's with the MEMFAULT and HDDFAULT value lists assigned the the popup menu should display the correct results of a list of values from the correct files where their ACTIVE status is 1. because they have been set to display second field only you should see a list as follows:-
      memory1
      memory2 etc
      and
      hdd1
      hdd2 etc

      Actual result

      the above works perfectly in filemaker 10 and 11 but in version 12 when you select the TEMP TEST FIELDS's with the MEMFAULT and HDDFAULT value lists assigned you will get a list of the following:-
      hdd1
      hdd2
      hdd3
      hdd4
      hdd5
      hdd6
      memory1
      memory2
      memory3
      memory4
      memory5
      memory6

      this should not happen and only seems to occurr in filemaker 12 works perfectly in 10 or 11.

      it seems that 12 is ignoring the first field values
      i have sample databases available if required

      Workaround

      NONE - that i can see