I have a BindingSource for a child table bound to the Foreign Key relationship of the Binding Source for its parent table e.g.:

ChildBindingSource.DataSource = ParentBindingSource
ChildBindingSource.DataMember = FK_Child_Parent

This works fine if I bind a DataGridView to ChildBindingSource. Only child records for the selected parent are displayed. However, I can't get it to work via the ChildBindingSource List property. I need to populate a list in a toolstrip combobox with the Children of the selected Parent.

The List property of the binding source returns the entire Child table from the dataset, not the joined table from the FK relationship, so includes all child records, not just the selected ones. The returned List also ignores any filter property that is set.

How can I access just the selected Child records programatically from the BindingSource? The alternative is to go direct to the dataset, I guess, but this defeats the purpose of the binding source.

Thanks,

Rob

Hi Rob
FK relationship had problem. You can test FD relationship

Can you post your code??

---

C#...Oh yeah