>(3) If I create the view programatically (in my form's code somewhere), how can I test for the existence of the view, so that once the view is created, subsequent program executions will not attempt to recreate it. (or will "set safety off" avoid errors?) I am using REQUERY() each time the user choses a different customer.
You will not get an error for trying to create the view twice, only a dialog asking if you want to overwrite existing one. SET SAFE OFF gets you around the dialog.
I am glad you got your other issues worked out.
Erik Moore
Clientelligence