compare listbox value

[omid5ive]

hi

i have two list box with this value:

first listbox=A,B,C,D

2nd listbox=B,C,E

i want to have third list box with the value of diffrence from first and second listbox

third listbox=A,D

how can i fix this problem?

[Gysbert_Wassenaar]

It's not quite clear to me what you want. See attached qvw. It has two approaches, one using alternate states and one using three fields.

[omid5ive]

thank you

but i want to have list box with diffrece between first and second table

for example:

in first table we have this values :    A,B,C,D

in 2nd table we have this values: B,C,D,E

i want joint value

B,C,D

[Anonymous]

I have the same question.

In SQL this can be done by UNION [ALL], INTERSECT, MINUS.

Having two listboxes, 'the result' of the two fields should be calculated dynamically.

Eg:

F1: A, D

F2: B, D

F3(UNION): A,B,D

F3(INTERSECT): D

F3(F1 MINUS F2): A

Any idea ?