Get colum value from a datagrid

Hi


I have a datagrid filled with some data from a SQL-querry.


for ex i have one colum named Company and one called Ref.
These two comes from a diffren table ( i have used a join sql-querry to get them.) Each of them has his own idnumber. I want to be able to click on the name in the cell and den recive the idnumber so that i can use an sql=querry to get all of the information on the company and display it on another datagrid for ex..

Ho do i do that....i am new at this and need a basic explanation

thanks!


/tyson