Hello,

I have 3 tables

Tables
Chairs
TableToChair_Relationship


I am working with these tables seperately. I have found
that by using a dataview, I can filter the datatable.
This is great... what I need to do now is to
relate Tables to TableToChair_Relationship to Chairs using
a datarelation.

Questions:
(1)Can I relate 3 tables using the datarelation?
(2)How do I use dvNew.RowFilter to only return all chairs
that can be available for a given table.
(3)I currenly set the dataview to a datatable.
dvNew.Table = dsTest.Tables[0];

Should I set the dataview.Table to the datarelation?

Please help..
Thank You,

Alvin