>Nadya,
>
>I suggest you bypass the view.
>
>Start with a list of data you need in the end result. Then find the shortest route. Use the diagram to find it
>
>The mmVisCollect seems to be the databaae. The view is rather complex. Too many tables involved. Do you need that many tables in order to get to the result ?
>
Yes. I can not bypass the first view v_QuickSearch. However, I may get rid of other views. The Mere Mortals framework we're using requires Business object, which needs at least one view.