Conditional Value Lists problem since upgrading to FM Pro 13
I have upgraded to FM Pro 13 and are now having a problem with a Conditional Value List and the Drop Down List values that are being display. The list should show related values from the second field with numbers ranging from 1 to 50 but instead is only bring up 1,10,20,30,40,50. If I go on an iPad that is still running FM12 it works fine with all the correct related values. Also if I remove the tick for "Show values only from second field" it also works correctly. Not sure if its a technical issue or something not quite correct in my database but it has worked fine running our rental last year. I have attached a screen shot that is hopefully visible.
Yes, this bug has been reported and acknowledged by FMI. Until they correct it, one workaround is to base the value list on a new calculated text field = Right( " " & ReferenceNo ; 2 )