You could change your WHERE clause to something like this:

WHERE CustNb = ?MyCustNb OR ?ShowAll = .T.

You could then get all customers records by initializing MyCustNb to the customer number and ShowAll to .F. To get all records, you set ShowAll to .T.

HTH

>I have created a parameterized view which is parameterized on a integer type field relating to customer table, so if I want to only show certian customers records I pass in the customer key. My question is how can I view all the customers records?