I don't know if this is possible, but here goes... I have a dataset containing three tables - one parent and two children. I have relationships set up between the parent and each of the child tables, but not between the child tables as they have no common fields. When I expand a row, I want both of the child tables to show in the same band. Can it be done?
JebusJunkie,
Nice name, eh...
Even Microsoft Access doesn't display two child datatables in the same band. If it realizes that you have multiple tables connected via primary keys and foreign keys it asks you to select the child table you want to view. I think this is mostly a user interface issue - and not a data management or technical issue. I mean, how would you display the contents of row one of talble one with row one of table two. Odd, very odd...
But, how about prefilling a webcombo with the potential child tables that can then be used by the customer to select the child table he/she wants to view??? With some work, I think you could even place the webcombo inside a column in the parent table band. You would have to rebuild the dataset and relations on a change in the webcombo.
Once the relation is set you will have a parent/child webgrid that the customer has chosen.
Not perfect, but I see no other way to visually cue the customer
Roger Bogh said: I mean, how would you display the contents of row one of talble one with row one of table two. Odd, very odd...
I mean, how would you display the contents of row one of talble one with row one of table two. Odd, very odd...
In the situation with 1 parent table and 2 child tables, you would expand row 1 of table 1 and the expanded row area would show 2 grids. All of the rows in table 2 that relate to row 1 of table 1 would be in one grid and all the rows in table 3 that relate to row 1 of table 1 would be in the other.