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.