Hi Stephen ---

>How to define a view that is created via a union and use it?
>
>I have a table of sales orders (shipped) and SO (open). I have unioned the 2 together and I want a vp_CustNo as a parameter. How do I code that in the Create SQL View command?
>

CREATE SQL VIEW vue_orders AS ;
   SELECT * FROM shipped WHERE custno = ?vp_custno ;
   UNION ;
   SELECT * FROM salesopen WHERE custno = ?vp_custno

>This parameter is going to be populated by user selecting a customer from a view off the first page. The # of pages on this form set is growing daily. It's a customer support system and the wish list is growing way to fast.
>
>Any reasons not to do a 6 page formset in MM & CB?
>
>__Stephen Russell
>Memphis FPUG