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.