Hi i want to represent a many to many relation in my wpf appliaction.I want to fill a combobox in my listbox according to a relation.But my parent table does not contain a primary key.So i am not able to add a relation also.My tables are as follows
Tests Table(no PK)
............
Id TestName Sample
1 Test1 Blood
1 Test1 Serum
2 Test2 Blood
Lab Table(Id is a PK)
..........
Id TestId Lab
1 1 Lab1
2 2 Lab2
I want it to be displayed in a listbox like
Test1 Lab1 Blood
Test1 Lab1 Serum
Test2 Lab2 Blood
where lab and Blood are represented in comboboxes.I want the comboboxes to be fill from the relation.How can i do this...?