John,

You can't parameterize the FROM clause using the view designer. You can create views on the fly using CREATE SQL VIEW or use SQL Pass Through (SQLEXEC()) to build a SQL statement and send it through ODBC.

>I am querying a remote database by ODBC and have no trouble parameterizing the "where" clause. It seems that you cannot parameterize the "FROM" clause. Is that true ?
>TIA
>John Harriss