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!