>>>>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...

Thanks Sonny... once again, you have helped me out... It works
and thanks again...Rob