Evelyn,

Let's suppose your customer table has an AreaCode field and we want to create a view to extract customers in a some user-specified area code.

You then create a view for this right?

First, you specify the tables needed (in our case it's only Customer)

Then, in the Fields, let us say we just want to view CustID, CustName.

Then, in the Filter Page, we put something like AreaCode = ?pAreaCode (the question mark right before pAreaCode is where the 'parameterization' occurs - it tells VFP that it should ask for the value)

Then, in the Query menu select View Parameters. Here, add pAreaCode to the list and define it as Character.

Save the view (let's name it vueCustomerPerArea)

To use the view: (OPEN IT LIKE ANY TABLE)

USE vueCustomerPerArea NODATA

pAreaCode = <somevalue>

REQUERY( "vueCustomerPerArea" )

BROWSE

>i have set filter on my grid. and, it's very slow. i know i have to use p-views, but i do not know exactly how to do it.
>
>can anyone guide me pls?
>
>TIA.

Hope to help,

Dennis