>Grid in grid and container in grid works but harder to make them work as you ...
I have been playing with a container of textboxes but havn't completly given up on a grid in a grid. Plan to play with it some this weekend to see if I can resolve some of the problems there. Thought of some of the other options (related grids or controls) but since I have to allow them to sort and filter the parent file I have using a view to consolidate the data for navigation. It would be nice to use dynamicbackcolor to highlight cells for trucks needed on a job. This is one feature that may not be possible with the container of textboxes.

>For textboxes select on entry problem, having a this.setfocus() in gotfocus()..

The problem here is that I have the SelectOnEntry set to .T. for the textboxes which all work except the first box in the container. No matter how you get there ( click, tab, alt-tab, enter ) it does not select the text, it just places the cursor at the begining of the box. Something that probably has a bearing on this is that whenever the container gets focus the focus goes to the first box (for example if I toggle to the debugger the active control within the container moves to the first textbox in the container).

>... IOW sizing containers in a grid on the fly is really tricky (IMHO).

For all of the great functionality of the grid it still seems a little fragile and I agree. Once a grid is in place I aviod resizing or repositioning colums, etc.

>Flexgrid and hierarchical flexgrid (treeview like grid with +'s) are supported in VFP as activex controls using ADO. ADO loading is relatively slower but not very slow as I could test.

Haven't tried flexgrid. Have you had good results with it? What features lead you to use it? Any gotchas?

>Dynamic* set are powerfull properties of grid and work quite well when used with sensible expressions. ...

Agreed, this is really the main reason that a grid in a grid is so appealing.

>Making the grids multipl (parent-child-grandchild) and a supporter view based summary grid could be an option. ... You could even mimic grid with a series of containers that are not in a grid.

I'm not sure that, given the sort and filter situation, syncing multiple controls outside of a grid wouldn't be more difficult than placing them in the grid. The problem is the job at a glance issue. They need to see job info and truck assignments for multiple jobs on a single screen.

>If they're already doing it excel, it could be a basis for design. And/or VFP+Excel combination could free some screen real estate :) (As a note: At least with VFP6 SP3, Excel2000, Win2000 tested - you can put toolbar and buttons in excel and control their click etc events from within VFP with VFPCOM).

Havn't looked at VFPCOM yet. Maybe it's time.

>On a generalized subjects like this it's hard to directly help but as you go on and need help in specific areas UT members will be here. Go for it.

>Good luck:)
>Cetin

Thanks, lots of good input.