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.