Selection in Listbox

[#1]

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!

[john_duffy · Accepted solution]

Hi Stef.

I was able to get your expression to work in a list box.  Set List Box 1 in the attached application.  Also, I created List Box 2 which will display the value for PackageNb if the user selects an OrderNB and Article.

Let me know if this helps or if I am not understanding the issue.

John.

[#3]

That's just what I needed. Your example is great! Thanks a lot!