InfoPath Dev

It's good to have a nice place like it here.

I have created a form with a direct database connection consisting of 4 tables. The hierarchical view of these tables looks like this: A->B, A->C and C->D (I hope this is clear to represent the relationship). In the form, I need to construct two master/detail controls for both A, B and C, D. The control for A, B works fine, but not the other one. I wonder if there's a way to work it out? Thanks!

 The way I created controls:

create a control -> bound it to A in the datafileds (Works)

create another one -> bound it to C using same database connection (Not working properly. The query works fine, but the detail view doesn't change with the mouse click on the master view)
 

I am not sure you can have two master detail setups in one form.

But you can replicate this functionality with views and controls. That is what I would do for your C D. Have a hidden section for the details in D and have a button that selects the current() row C data and then exposes the D data.