>Using a view instead of SET FILTER why not ? But the problem will be to refresh my local grid to display correct data, because using a network, change could be done by other users, then it will be imperative to regenerate my view each time my user finish a transaction to be sure he've got the last data on grid.
Well You can simply call refresh() to fetch changes done since opening it. That's just like refreshing the filter. I am not sure if it will cause the grid to show only white after that (never tried). In this
case You would have to
lc_WasRSource = This.Grid1.RecordSource
This.Grid1.RecordSource = ""
Refresh(..)
This.Grid1.RecordSource = lc_WasRSource
I think it should work.
HTH