More on views....
You could use a paramater in the WHERE cluase of the view.

For example the view definition: CREATE SQL VIEW "myview" AS SELECT * FROM mytable WHERE id = ?vpid

To load the view use the following code:
USE myview IN 0
vpid =
=REQUERY("myview")