>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

Alvin,

You will have to use a DataSet to define relationships. The DataView class does not support relationships.