Mike Yearwood
Toronto, Ontario, Canada
General information
Category:
Coding, syntax & commands
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.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only