12 Replies Latest reply: Aug 23, 2011 5:08 PM by Jan-Hendrik Esterhuyse RSS

    Input Box and Concat

    Jan-Hendrik Esterhuyse

      Hi

       

      Previously I was able to use the function = concat( Distinct Company, ',' ) in a inputbox's Listed Values text box on the Constraints tab.

       

      This allowed me to show all the different company names as drop-down values in the input box.

       

      When I try to do this now (currently in version 10, SR2), it show the drop-down values all in one row, for example Company1,Company2,Company3 etc. (see screenshot below). I also tried it using another delimiter ; in the function, but this also gave the same problem  = concat( Distinct Company, ';' )

       

      image.jpg

      image2.jpg

       

      I would appreciate it if someone had an idea / example of how I should go about to do this.

       

      Thank you

       

      Jan-Hendrik