I am creating a report in Visual Foxpro 6.0 based on an SQL 2000 view. I would like the view to ask the user for a sales order number and then run the view for just that sales number. Can an SQL view do this?

Thanks
Jim