Filtering a childtable to result same filter on parentable

[Gandalf23]

Hi all,

This is what I try to achieve:

I make 2 select statement which result in a table "Client" and "Client_Cars"

I put these two in a DataSet and put a relation between parent and child table.

This dataset is the DataSource of a DataGrid on a form.
All well this far.

On the same form there is a combobox with a list of cars. What I want to do is that when the user clicks on a specific car (for example BMW) in the combobox, the DataGrid only shows Clients that have these BMW cars.

The problem is that I have to set te filter on the childtable and expect that the parent table changes too.

Can anyone help?

 

[palbano]

Here is a link to an example of doing something like that in a MSDN Magazine Article a few issues ago:

http://msdn.microsoft.com/msdnmag/issues/03/08/CuttingEdge/default.aspx

-pete

 

[Gandalf23]

Tx, your post was helpful