1 Reply Latest reply on Mar 31, 2013 7:43 AM by LaRetta

    Question about list

    user19520

      Hi,

       

      New to filemaker, I am facing a strang situtaion. I have created a list from categories tables (id, description, fkparentcateg). When showing both Id and description, I can use it as menu list ou drop down without issue. If I set my list to show only seconde field (description) I got ? in my list instead of the description.

       

      Any suggestion

       

       

      Ben

        • 1. Re: Question about list

          Hi Ben,

           

          If the second field ( right pane ) in the value list selection is text and you actually have the second field formatted as number in your field definitions then it will display ? when you pop the field if the value is text only ( no numbers ).  If it contains any number then FM will index it, ie, 123abc will work, but without a number in it, it will produce ?.  You can verify what will work by entering the field (either while edit box or drop-down) and typing CTRL-I to see the index.  Is this what you are experiencing?  This issue would also be present with drop-downs however so it may not be your issue.

           

          If the second field is NOT number by accident then it might be tied to an existing bug with version 12.0v3 on windows with pop-ups where they do not properly display until the format is changed from general to as entered in Inspector > Data > Data Formatting.