Hi,
I'm tring to filter a dataview based on the value of the child datatable
For example:
Clients (Parent)
Id (PK)
Name
Address
...
Orders (Child)
Id (PK)
Client_Id (FK)
ItemCode
ItemName
...
The relation for the two tables has been setup and I have a ListBox on a form to show the client names... I use a normal DataView and it works fine, but I want to filter the Clients by the ones who have brought a TV for example...
I have read that you use the DataViewManager, but after playing around with it and finding out that it works the other way (Filter Parent to get Children), I'm stumped...
How can I do this?
Thanks in advance
I'm tring to filter a dataview based on the value of the child datatable
For example:
Clients (Parent)
Id (PK)
Name
Address
...
Orders (Child)
Id (PK)
Client_Id (FK)
ItemCode
ItemName
...
The relation for the two tables has been setup and I have a ListBox on a form to show the client names... I use a normal DataView and it works fine, but I want to filter the Clients by the ones who have brought a TV for example...
I have read that you use the DataViewManager, but after playing around with it and finding out that it works the other way (Filter Parent to get Children), I'm stumped...
How can I do this?
Thanks in advance