AnsweredAssumed Answered

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

Question asked by richardwilton on Apr 14, 2012
Latest reply on Sep 10, 2012 by ronhofius

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

Outcomes