I have the following tables and relationships:
RCM_OBJECT_TYPES -> RCM_TECHNOLOGY_TYPES -> RCM_FMECA
|---------> RCM_FMECA_FUNCTIONAL_RQR -> ....
So in total I have 8 tables
RCM_TECHNOLOGY_TYPES has 2 child tables RCM_FMECA_FUNCTIONAL_RQR + RCM_FMECA. The problem when I associate an ultragrid to this datasource, it only has 3 bands. It only includes the relationship RCM_OBJECT_TYPES, RCM_TECHNOLOGY_TYPES, RCM_FMECA. The other relationship branch RCM_FMECA_FUNCTIONAL_RQR, RCM_FMECA_FAILURE_MODE, ... is missing. I need to have 2 children off of technology types.
I assume multiple children are allowed but I can't seem to get the children to be found via the ultra grid wizard attaching. It was working fine before I added the 2nd child table (RCM_FMECA) -> aka I had 7 bands but all 1 table to 1 table. I simply tried adding another table into the list and it doesn't show up.
Am I doing something wrong???
Ok, I got it figured out - something was wrong in data set...