>Hi All
>I have two grids in a form. The first grid uses a parametized view as datasource, and works great. I would like the second grid to populate depending on the current selected record in grid 1. I would like to also use a parametized view in the second grid ( this way, in my Afterrowcolchange from grid1, i just set the params from the current record, and requery the second view ). The problem is that for the second grid, my select statement should use the UNION clause, to combine from 2 queries. Is this doable? If not, i'll have to set recordsource of grid2 to the sql statement with the union, but i guess this will take more time...

Take a look at View Designer replacement eView file #9474 and ViewEditor from http://www.geeksandgurus.com/vfptools/vieweditor.htm.