As Sergey has recommended, you can do this with a third party tool like ViewEdit, or you can do it yourself in code. It depends on whether or not you're more comfortable with a visual IDE or not.
>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...
>
>TIA
>Jaime