>I have a user interface with a grid using a parameterized view as a record source. The customer has asked me to broaden the selection criteria to include field values in the view OR on values in an external table a nested select. Is there a way to use the view designer to combine or choose between these two filtering methods? Is it possible to use macro replacement for this purpose?
>
>Any guidance would be appreciated.
>
>Thanks
>
>John

Can you switch to Cursor Adapter instead? This would be an easier solution for variable where condition...