I don't think mixing tables and views should cause you any distress.

The problem might be a non-optimized view - remember that a view is a query. Try opening the same view, with the same parameters, from the command prompt. See how long it takes.

Hilmar.

>I am having fun with Visual FoxPro once again.
>
>FORM'S DATAENVIRONMENT:
>I have one Local View, vProjects, which selects two fields, Project_No and Proj_Name, from the Projects table. I also have 3 tables in the DataEnvironment.
>
>As the WHEN Event of the first control on the form hits, I INDEX the two fields in vProjects.
>
>The form seems to take about 5 or 6 seconds to load, possibly due to the relations set in the DataEnvironment, or maybe the execution of the view.
>
>The form has 4 grids on it. Each grid represents a view or table.
>
>vPROJECTS does a 1 to Many relation out to the POHeader table. POHeader does a 1 to Many out to 2 tables, PODetail and Costs.
>
>vPROJECTS (Project_No)
> |
>POHeader (PO_Main)
> |
> PODetail-------------Costs
>
>I read someone's opinion that we should not mix Tables and Local Views in a DataEnvironment. Why not?
>
>Is the opening of the above tables what may be causing the form to instantiate more slowly. It seemed faster when I didn't use a View.