How about creating a dynamic set of textboxes - say, they have located the item, you could just build an array of available color/size combinations, and arrange them in a "grid" with just textboxes to accept the quantities. For each color you would have one line, for each size a column. Just line up the textboxes, and enable only those where you allow sales. Such a thing may be built dynamically at runtime. I've done something similar with questionnaires once, and with user-defined fields on another occasion. You need two levels of containers here, so the inner container can scroll inside the outer container. Scrolling the row and column descriptions synchronized with the textboxes would be a challenge, though; they'd have to be in separate containers at the same level, but it's doable, no doubt.

>I still think it's doable, Allan. If you want to bounce around ideas, I'm open.
>
>>Gerry,
>>
>>There are many more items.
>>Actually, this was only an example.
>>Each of these 'grids' is probably about 2 * 2 to about 10 * 6 plus columnar headings and another couple of lines to describe the product group as shown.
>>Some of the cells will have to be protected because a particular colour/size may be not for sale.
>>There will be probably be about 20 of these 'grids'.
>>
>>>This looks like such a "small" grid (5x4), I would simply use a VFP form with textboxes and use array reference to the textboxes.
>>>
>>>I would look at the different products in question and see if the creation of the input forms could be (meta) data driven.
>>>
>>>>I was brainstorming today with one of our clients who is using one of our order entry applications.
>>>>The appearance of the current application is probably somewhat typical in that the products are in the grid and each line has the item #, description, price, quantity (entered by user) and extension of the line.
>>>>He mentioned that several of the endusers would rather see the input screen in a spreadsheet format such as:
>>>>
>>>>Gloves - Leather
>>>>Mens
>>>>Colour S M L XL Total
>>>>Black
>>>>Brown
>>>>Grey
>>>>Total
>>>>
>>>>The endusers would enter the qty's per colour/size and Excel would calculate the totals both for the colour and the size.
>>>>Also, each colour/size would be a different item #.
>>>>
>>>>From a tecnical viewpoint, I would prefer not to use a hardcoded Excel template but build the speadsheet in VFP 7 and invoke Excel. When they are finished, I would want to bring the data back into VFP 7.
>>>>
>>>>Has anyone done something similar and hopefully point me in the right direction?
>>>>TIA.