>>>I need to CREATE a subset VIEW of an existing VIEW.
>>>Example…, I need to extract records from a VEIW TABLE for different departments and let those users only access their department.
>>>Any ideas?
>>
>>Hi Robert, Use a parametrized view With a Filer ----> cDepartment is like ?plDepartment
>
>Hi Sonny and thanks for answering... Could you give me a little
>sample code? I have never used parametrized views.
>thanks again..rob

You could do something like this :

CREATE SQL VIEW myView AS
SELECT * FROM myTable WHERE myTable.cDepartment LIKE ?THISFORM.plDepartment

THISFORM.plDepartment is a property that you could set in your form or you could use a public variable.

You could do this in the view designer...