Thanks Larry:

Are you referring to as a parameterized view created using SQLPREPARE() and SQLEXEC()?

If yes, I can not seem to get a positive connection handle at the initial SQLCONNECT(). My database name is AMS.dbc and my table is Customer_Ship_To.dbf. I don't have any passwords or anything set up.

If no, can I set up parameters in the Query Designer?

Thanks again