AnsweredAssumed Answered

Dropdown Menu Bug

Question asked by ralvy on Jun 29, 2009
Latest reply on Apr 21, 2012 by ralvy


Dropdown Menu Bug

Description of the issue

FileMaker Product(s) involved:FileMaker ProAdvanced 10 v2 Operating System(s) involved:Windows XP SP3Detailed description of the issue:When a Dropdown Menu is based on a field, using that Dropdown Menu will not let you find strings that begin with repeating numbers or characters. Exact steps to reproduce the issue:1.  Create a database with two tables: Test and Test2.2.  Create the same field field in each table (Text or Number, doesn't matter).3.  In Test table, create a Value List based on the field in Test2 table. 4.  Create six records in Test2 table, with the following values in the field, respectively: 110, 111, 112, a, aa, aaa. 5.  Define a Dropdown Menu in Test table on the field. Assign the above Value List you defined in Step 3 to that Dropdown Menu.6.  Go into New Record mode in Test table. Activate the Dropdown Menu and type '111' or 'aa' or 'aaa'. I find that typing any oither value (110, 112, a) works fine, in that the highlight bar moves to the desired object. But not for 111, aa, or aaa.Expected Result:I should land on the desired object. Actual Result:Highlight bar doesn't move to desired object.Exact text of any error message(s) that appeared:N/AAny additional configuration information/troubleshooting that is relevant to the issue:If the first two characters or numbers are not the same, the problem vanishes. That is, if the values found in the field are 21, 211, 2111, any of those values are found when using the Dropdown Menu. The same is true with 'ba', 'baa', and 'baaa'. Lastly, in initial case outlined above (Number field values 110, 111, 112), if you just type some letter, or the number 0, before typing 111, you get where you want to go (111). Read this thread in our forum that discusses this in detail: Any workarounds that you have found:None.