>We need to display all the color/size variants of an inventory item in a grid. We could build a grid and use a grid column for every 'color', but the challenge is that the number of colors can vary from item to item. For instance, one inventory item may have 5 colors and 5 sizes associated with it, while another may have 6 colors and 4 sizes.
>
>Every time I retrieve the color/size variants for an inventory part I could end up with a cursor with a different number of columns; i.e. in one case the cursor may have 5 fields/columns for the 5 colors, while in the other case it will have 6 fields/columns for the 6 colors. This makes it difficult to use the IDE to design a gridview.
>
>Anyone know of any solutions or examples that deal with this?
>
>Thanks.
Alain,
Probably I'm misunderstanding. Isn't it 3 columns grid?
Item Description
Color, Size, Stock
If something like a crosstab or hierarchical then consider activex MSHiearchicalFlexGrid or HTML.
Would you elaborate what you want to achieve. Is the problem only in IDE designer?
Cetin