>Is there a way, programmatically or from the desinger to use macro substitution in a view? I have an application that takes a user-defined filter and creates a fairly complex where clause. I create a tmp table and update the master from this. I'd rather use an updatable view.

'WHERE' clause should be created in this manner:

SELECT...;
WHERE table.field = ?varMyVariable...etc.

You can accomplish this in view designer, or write it directly.