select 2 values in a list --> and get an "and" result

[#1]

I want to select 2 values in a list, e.g. two colors in my example. But then I see each city which has this color in the list but I want to see only the city which has all the selected colors.

See example attached.

Best regards

Thomas

[nagaiank · Accepted solution]

Try using and-mode listbox. An extract from QV11 Reference Manual is below:

14.12 And-Mode in List Boxes

A multiple selection within a field is by default interpreted as logical OR, which means that data associated

to any of the selected field values will be shown in other fields. It is however possible to set certain list

boxes to And mode instead. When multiple selections are made in a list box set to And mode, the associations

in other fields must be to all selected values, which is exactly how associations are normally made

to multiple selections in several fields.

[#3]

Thanks, I found it, but it is disabled.

ok, will see how I can enable it.

[nagaiank]

The following may be of some use.

http://www.youtube.com/watch?v=Wg5Jgnki7yE