Datatable filters.

[anon]

I have a data table(A) and want to be able to use this to filter the second
data table(B) to show just the required rows.

So for every stock Item (grouped by ITEM, CODE) I want to create a second
list of each item and code from the table of transactions so that I can
analyse this second table.

I have been trying for over a day now, and am completely confused now as how
I should achieve this.

Originally dtTranSumm holds all the transactions, but I wanted to set it to
a filter condition part way through a process.
I tried to re-assert the dtTranSumm.Select("ITEM='1234' AND CODE='ABCD'")
but this did not return dtTranSumm with the filtered rows - in fact it
returned every row from the original table instead of the three I was
expecting.

Using VBNET 2002
Thanks in advance

Terry

[Jeff Louie]

If you are asking how to filter a master detail relationship you can
load all the
master rows into one table and all the detail rows into another table,
create a
relationship based on the _default views_ and store the whole tamale in
a
dataset. you can filter on the master view. as you iterate over rows in
the
filtered master view you can display the related rows in the child view
in a
databound datagrid.

Regards,
Jeff

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!