One-to-Many relation

  • Thread starter Thread starter N! Xau
  • Start date Start date
N

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
 
Back
Top