I've got two suggestions...First, you can continue with what you're doing by creating the view manually using the CREATE SQL VIEW command. However, you may actually want to dynamically build the view at run time...specifically the WHERE clause, based on the user's input.
Regards,
Kevin McNeish Eight-Time .NET MVP VFP and iOS Author, Speaker & Trainer Oak Leaf Enterprises, Inc. Chief Architect, MM Framework http://www.oakleafsd.com