I have created 2 instances of this semi complex senario (similar to my previous post). To start off, I have a many to many database relationship between 2 tables, so I created a linking table inbetween. Take a dataset, make 3 tables, create
a relationship from one table to another to the other. So table A is has a many to many relationship to table B via table C (which simply links Aid, to Bid in a bunch of rows). Take a WPF window, make 2 datagrids, one based on table A, and one
based on the relationship table A has to table B. (bind through the relationship not directly to the source table). When you select a value in table A, table B's related values appear, and not the whole table B. Got that far?
Datagrid B, for the relationship, is going to be bizzare... Make a custom datagrid, add 1 column (a datagridtemplate column). In the CellEditingTemplate, add a single combobox, with ALL of Table B as an ItemsSource. (we now should have 4
CollectionViewSources, All of Table A, Related A to C, Related C to B, All of Table B). This can be done simply by using the DataSource window and opening table A, then open table C (inside of table A), then open table B (inside of table C,
inside of table A), then drag table B into the window. WPF will create all
View Complete Post