>One way to do this is to create views for the child grid.
>You can then add index to the view and also filter. It is the best way to do child grid.
>
>Also, one way to prevent losing grid setting is to create a class for the grid and create the grid object at runtime when the data change.
>
>

>Thisform.LockScreen=.t.
>thisform.removeobject("MYGrid")
>Select * from Mydata into cursor MyGridData
>thisform.AddObject("MyGrid")
>thsiform.LockScreen=.f.
>

Pretty useful, thanks