I have a worksheet with the following columns.
Item Number, Description, Group
I would like to display the sheet in a treeview control with the Group as the parent, and the Description as the child. Each group can have multiple Item Numbers and Descriptions.
I would like the key of the each child to be the Item Number, which is the data I will need when the desired node is selected. Since the Item Number is numeric, I know I will have to add a letter to keep from causing an error. I was thinking of just adding the letter A for this.
I have a few ideas on how to do this, but I'm not sure what is the best way to go. There are about 1800 lines in my worksheet and probably 30 or so groups if that matters.
Item Number, Description, Group
I would like to display the sheet in a treeview control with the Group as the parent, and the Description as the child. Each group can have multiple Item Numbers and Descriptions.
I would like the key of the each child to be the Item Number, which is the data I will need when the desired node is selected. Since the Item Number is numeric, I know I will have to add a letter to keep from causing an error. I was thinking of just adding the letter A for this.
I have a few ideas on how to do this, but I'm not sure what is the best way to go. There are about 1800 lines in my worksheet and probably 30 or so groups if that matters.