I have a search combobox, on a master detail form.
dataset 1 has two datatables and a relation linking them through primary key and forigen key.
The parent in this relationship has a parameter in its Sql statement, it uses the selected value form the cocombox to fill the datatable, The problem is that the child table fills with all the record from its dataAdapter then it has an error, "The dataset is violating the forign key constraint". Im assuming this is because it is retreiving all the child records instead of just the ones for the parent.
Help! Do i need to set the child with a parameter two?