In the FAQ on this site, the procedures for building a triple layer relationship between grids is detailed. I''m building something that deperately needs this functionality, but I cant seem to make it work.
First, the tables are the exact tables from the Northwind database. (Categories, Products, Suppliers)
I''ve got these tables in a Dataset in memory, and I have added relationships as follows:
Here is how I bind the grids:
CategoryGrid.DataSource = gate.ShogunDataSet.Tables["ProductCategories"];
MyDS.DataSource = MyDS.Tables["ProductCategories"];
this.ProductGrid.DataMember = "ProductsToCategories";
this.SuppliersGrid.DataSource = gate.ShogunDataSet.Tables["ProductCategories"];
this.SuppliersGrid.DataMember = "ProductsToCategories.ProductToSuppliers";
Sorry, I sent that last message before I could finish stripping out irrelevent code and replacing the object names ,shogundataset, with MyDS. Also, the table name "ProductCategories" is actually "Categories". Is that too confusing? I apologize for making it so complicating! Thanks in advance for any input!