I have a database that looks somewhat like this:

Name - Item1 - Item2 -Item3

Test -sd -ds -jk
Test -st -dd -jl
Test -ss -dh -jj
test1 -ds -jk -kl

Etc.
Test is enetered in the table multiple times. I want to show the name column in a listbox. I already have code to do that and I remove the doubles so that Test only shows up once. Here is the problem. I want to click on test and in another listbox or textboxes have all three of the other values appear for all the Test entries.I.E.

Listbox1 Listbox2

Test -------------> sd - ds - jk
st - dd - jl
ss - dh - jj

I know it is confusing but oh well.