I am wondering if I could use a WebCombo to list child records for a row. I have a DB that contains Customer Information. Each of these customers can be assigned to different categories. Instead of creating a Hierarchial Grid, where the user has to expand a row in order to see the rows for the Categor a Customer is assigned to. I would like to put a Combo Box column in the Grid and populate that combo box with only those records (actually, it is a single colum from the records) that the customer belongs to.
I suppose it will have to be a templated field, since it isn't an "Edit" grid. Right? (Or, can I simply use a "ValueList" and forgo the Combo/WebCombo templated field?)
Also, how would you populate the WebCombo? In the Initialize row even search for the Combo box and populate it there per row? I guess that is the only option.
Thoughts/opinions/advice are appreciated!
I just realized someting. To make the DropDownList work the grid cells have to be "editable". The grid I want to do this on is just read only and when you clock the row, it opens a detail page.
I could make this single column "editable" and show the drop down list or a combo box if that is a possibility, but it seems I can only make the "entire" row editable using "CellClickActionDefault" and "AllowUpdateDefault". I don't see a way to set the field as a DropDownList and have the list clickable, without making the entire row editable. (Of course, I know that technically it may not "hurt" anything to have the row editable, but if the changes can't be saved then I am against letting the user make changes.)
Has anyone done anything like I am describing? The alternative is just to add a child bind and force them to expand the band to see the "Categories", for some reason the Manager of the department I am writing the app for doesn't like that....