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?

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