>Hi Mike,
>
>I've never really considered SPT because all of my tables are local. SPT seems like it would be more to manually maintain than a View.
>
>I have a solid, speedy application using the local views and I hate to rewrite (and retest) huge portions of my system just to get around this one issue.
>
>I appreciate your suggestion though and will look into SPT.
>
>Thanks,
>Paul

I haven't considered local or remote views to be a good approach for quite some time. The view designer being effectively broken for so long led me into other approaches. Even now you still can't use the view designer with macro-substituted views. Limping along on a broken crutch is not my idea of fun.