>>> Thanks in advance.
>>Yes Creating the view on the fly should be faster
I would test this first- creating a view on the fly and setting a bunch of view properties can take a while...
>>Then, when you want to delete the view:
>>USE IN Nadya
>>DROP VIEW Nadya
You should know that doing this repeatedly will results in a continually growing dbc file- Each time you create a new view and delete it, a record is added and deleted.
Erik Moore
Clientelligence