ADO.NET and WPF: Fill DataGrid with related data
===

Hej! I have two tables A and B and these two tables are related with a n:m relation (all done with MS Access 2010). So I broke this relation into two 1-to-many relations with a mapping table between A and B connected with the new relations (this mapping table has an own primary key and also contains the primary keys of tables A and B). I access this database with ADO.NET and use WPF to display the data.

Next, I placed a DataGrid with DataContext set to table A and ItemsSource bound the relation between A and the mapping table (ItemsSource="{Binding Path=Relation_A_Map}". This first step works fine and the DataGrid displays only the related data rows in the mapping table.

The problem is: I dont want to diplay the keys that are stored in the mapping table, I want the DataGrid to replace the keys (displayed in the data rows) with the related data in B. How do I manage this second step?

I would very much appreciate your assistance!