Find common values in a field based on other field

[#1]

Hi,

I have two fields, consider field1 and field2.

Field1 has two values 0 and 1.

Field2 has values like A,B,C,D,E,F,G.

These two fields are related to each other, if i select 0 from field1, it will filter A,B,C,D.

if i select 1 from field1, it will filter everything in field2 means A,B,C,D,E,F,G.

Now i want to get the common values between these selections. i.e., A,B,C,D

i want to get the common values in other listbox which should show A,B,C,D.

How can we get that?

[Gysbert_Wassenaar]

See this tutorial

[#3]

bydefault our selection of listbox work on union. if you want to work on intersection then must be used And mode option.

for this

simply load your table in script with Distinct keyword.

then right clik on the field1 and in general check the And mode option the select o and1 then your common field are selected in field2.

see attachement

[#4]

Now, I want to get E,F,G as a value in the listbox always.

It should not change even if we make any selections.

How can we get?

get excluded values, which is present in when field1=1, but not in field1=0.