2 Replies Latest reply: Sep 7, 2011 7:10 AM by stef.kaiser RSS

    Selection in Listbox

      Helly everyone,


      i have a database table that contains the articles sent to our clients.
      For each article sent, we store:

      - the article (Field Article)

      - the package-nb in which the article was sent (Field PackageNb)

      - the corresponding client's order number (Field OrderNb)


      Now, I need to create a ListBox that shows for a certain Order-Nb and Article, what Packages contain that specific article. 


      I tried to create a ListBox with dimension PackageNb.

      Then I created the following expression:


      if(OrderNb=12345 and Article='pencil123', PackageNb)


      But I dont get any values as a result. Could anyone tell me what I am doing wrong here, please?


      Thanks a lot in advance!