Mike,

Can you have more than one qty (size) in the same row?
This would save a lot of screen real estate.


>Hi Allan
>
>Consider a tree view.
>
>Gloves
>...Men's
>.....Leather
>........Colour
>...........Small _qty_
>...........Medium _qty_
>.....Wool
>...Women's
>......Leather
>......Wool
>
>You can subtotal by colour, material type etc, etc.
>
>>Gerry,
>>
>>I think that we would need the kind of control over the individual Excel cells that we have in a VFP grid.
>>For example readonly, combobox so that they can choose a discount, etc.
>>The more I think about it, the more that I want to use a VFP grid(s) or a form with text boxes (as you suggested).
>>I think that one of the main advantages (from the client's perspective) is that they can scoll up/down in an Excel spreadsheet and see the various groupings of gloves.
>>If we did not use a grid we would need either multiple forms in a form set and/or multiple pages in a page frame to accomodate the 100's of SKUs.
>>A grid would facilitate the scrolling ....
>>Your thoughts?
>>
>>
>>>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.