One-to-Many relation

[N! Xau]

Hi all,

on a form I have 2 datagrid. The first one shows data resulting from:
SELECT DISTINCT myField FROM myTable

There can be many record in myTable with the same myField value.
What I want is, when a user click on any record in the first datagrid,
the second datagrid displays ALL the record in myTable with that
particular myField value.

I have troubles to capture the click event on the 1st datagrid, and
therefore to associate the clicked value to the population of the 2nd
grid.
THANKS for help

N! Xau
http://ilovemiliofede.altervista.org

[W.G. Ryan - MVP]

Use a DataRelation and bind to it.
http://www.knowdotnet.com/articles/datarelation.html
"N! Xau" <nx**@hotmail.com> wrote in message
news:11*********************@g49g2000cwa.googlegro ups.com...

Hi all,

on a form I have 2 datagrid. The first one shows data resulting from:
SELECT DISTINCT myField FROM myTable

There can be many record in myTable with the same myField value.
What I want is, when a user click on any record in the first datagrid,
the second datagrid displays ALL the record in myTable with that
particular myField value.

I have troubles to capture the click event on the 1st datagrid, and
therefore to associate the clicked value to the population of the 2nd
grid.
THANKS for help

N! Xau
http://ilovemiliofede.altervista.org

[Cor Ligthert [MVP]]

N!Xau,

A sample with even 3 datagrids, there is as well one with OleDb on our
website

http://www.vb-tips.com/default.aspx?...e-e8335682ad3a

I hope this helps,

Cor