>Hi,
>
>>>As an aside, I never use the view designer and I code all my views.
>
>I have some sort of middle ground - if the views are simple and within the capabilities of the view designer I tend to stick with it since it's easier to go back and check the view settings.
>
>BTW - why do you delete the view before re-creating it - I thought it was automatically overwritten if it already existed ?

Correct, it does the overwrite.
Since I have Safety Off, deleting it first does not ask to overwrite it. And it is but one line of code.

Another reason I put the views in a function is to update the customers to the latest version if necessary. Each change to a table is also done with code. When any table has changed, I recreate all the (local) views since they may depend on a table just changed.

Just a way of working

Cheers,

>
>Regards,
>Viv