Master-Detail-Subdetail not getting refreshed when detail row changes

[Administrator]

Hi,

I have a the following table structure
Customer
Order
Order History.

Please run the attached sample.
When you highlite a customer, my orders are getting refreshed properly. But whenever, my I highlite an order its order history is not getting reloaded properly.

When I delete a customer, all the related orders and order history are getting deleted fine. I see the order history rolling along and getting deleted.

Please let me know what I am doing wrong.

[Administrator]

Try this.

Make the DataSource on all three grid the same.

subdetailGrid.DataSource = dataSet.Tables["Customer"];

Make the DataMember on the subdetail grid reflect the relation back to the master table.:

subdetailGrid.DataMember = "CustomerToOrder.OrderToOrderHistory";

[Administrator]

Clay,

That worked!!

thank you very much,
- Reddy