PLEASE HELP!!! PLEASE

I need some help please, I am using 2 listview controls and I am
getting the information from 3 tables within a database...

I am trying to display the information as so(please see below)
Also I want to be able to click on the item on the 1st listview,
highlight that info and show all the contents on the 2nd listview.

THE DATA INFO

TABLE 1 - Student Info
(Name, Address, City, State)

TABLE 2 - Student Classification
(Classification, Major)

TABLE 3 - Student Classes
(Classes Taken)


Info in listview 1 Info in listview 2

Name Classification Major Classes Taken

Joe Sample FR Marketing English
Algebra
Business Math
Prof Writing

You can try to:

1 - add elements to listview1
2 - in the dblclick event of listview1 you have to
see the selected item
3 - search with an SQL in your table2 & table3
for informations
4 - if found add these items to listview2

I don't have here vb so i can't write to you code (don't remembrer syntax!)

If you find this useful please rate, thanx.