Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Need data input grid for color/size variations of inventory
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Title:
Need data input grid for color/size variations of inventory
Environment versions
Visual FoxPro:
VFP 9
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01073047
Message ID:
01073047
Views:
47
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.
Next
Reply
Map
View

Click here to load this message in the networking platform