table box - remove ALL duplicate values

[#1]

Hi,

as a work around to my other problem posted, I tried to setup a table box and load data into it. Since it's a combination of multiple list boxes it will only show unique LINES. But I need to get only the unique VALUES or CELLs (so a value will only appear once in the whole table box).

As an example I'd like to get from the following table

Derivate.wID	Derivate1.wID	Derivate2.wID
A	A
B
C	B	D
A	B	A
A	B

to this table:

Derivate.wID	Derivate1.wID	Derivate2.wID
A
B
C
D

Thanks for your help in advance!

[#2]

See if this is sort of what you are looking for.  I am a little unclear on what you would want the remaining two fields to contain, but this provides a list of ALL distinct values from ALL three fields.

[#3]

Thanks Rebecca,

due to changed requirementes I won't pursuit this problem any longer.