I have a grid on a form thats based on a local view which works well. The user wants to be able use the same grid to get a view based on different parameters which would require a different kind of querry of the same underlyng data. Basically it is the exact same query with a different join type.


My thought was to create a second local view and change the data source property of the grid to the second view but when i switch to it the grid goes blank and when i toggle back to the first view the data in the grid is scrambled. Both views work when tried by hand against the data.



Is my whole approach wrong? Is there a way to programatticlay change the sql of the view to specify a different join?

TIA
Chris