Show excluded data

[#1]

Hi all.

I have 3 tables:
- Customers
ABC,
Nasa,
T-Airlines
- Products
Laptop,
PC,
Mouse
- Sales

In a listbox i want to select one Product, and the result should be a tablebox with the Customers who don't buyed this selected Product.

In Sales (Customer, Product, Quantity) i have the following records:
ABC, Laptop, 1
Nasa, Mouse, 2

So I select "Mouse" and the content of my tablebox should be:
ABC
T-Airlines

Is this possible?
Maybe someone could help me....

Thanks
Ivo.

[#2]

I think u can use set analysis in order to achieve this

count({1-$} Customer)

Use this expression in straight table and then hide that expression so that tere is only one field Customer

[#3]

Create the following expression in your table

=sum({1-$} Sales)

Returns sales for everything excluded by the current selection.

[#4 · Accepted solution]

This is what I was looking for.

Thanks a lot.
Ivo.