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