When using parameterised, updateable views, I want more freedom on the selection of the records : can a view dynamically be changed (it's WHERE cluase )?
Example : I want the same view based on a product file, a first time for all the products of within a price range FROM,TO (where price between X to Y), and another time the products of wich the price is X, Y or Z (where price in X, Y, Z).
I don't want 2 different views because these examples aren't the only possibilities and the view is the record source of a form ...