After reading your reply I realized that I had not correctly described what I want to do. I apologize for wasting your time with the previous request.
I have a table with two columns (there''s more, but this is all we''re concerned with right now): CompanyBusinessUnitID (CBUID) and ParentCompanyBusinessUnitID (PCBUID). If the PCBUID is null then the row is a top level row in the hierarchy. If it is not null than the current row has a parent. This is how the hierarchy is built.
This table represents a company employee hierarchy.
Is it possible to represent this with your grid? I think it is, but I don''t understand your grid well enough yet to get it to work.
Thanks for any help you can give me and again I apologize for misleading you previously.
This is possible in our grid. Here is the sample that shows the Grid in a hierarchical manner.
Our grid will not automatically display in hierarchy structure by using the join query. To display grid in hierarchical form you have to define the “GridRelation” for parent and child table.
Steps to define hierarchical grid:
1) In the properties window choose “GridRelation” under Table Descriptor.
2) “GridRelationsDescriptor Collection Editor” opens up.
3) Add a new member and then choose the childTableName to the member.
4) Choose “RelatedMasterDetails” value for Relationkind property.
5) Choose the “RelationKeys” property. “RelationKeyDescriptor Collection Editor” opens up.
6) Add a new member and choose “ChildKeyFieldName” and “ParentKeyFieldName” to the member.
7) click “ok” button. Displays the grid in hierarchical form.
In this sample I have recursively joined with “OrdereID” column.I have used Orders table from NWIND Database. Please have a look at the sample and let me know if you have any queries.