The view designer doesn't work well with more than 2 tables in a view. This is a limit of the view designer. VFP SQL can have many many tables. For a report you might want to consider just using a cursor generated from your tables. The power of a view is that updated data can be sent back to the base tables. In a report this feature isn't useful.

>My question on the subject is because I need to create a View that will be the base for a Report. This View must have fields from seven different tables, these tables being connected by relations.
>
>When I finish my desing work, in the View Assistant (I work in a spanish version, so maybe it has a different name in the english version), when I try to leave it, it says it can't find a certain field that is already in one of the tables of the DataEnvironment of the View! sO, When, later, I try to reopen to modify it, it appears with only the tables inside, no relations, no fields selected!
>
>I took the SQL generated command and tried it in a PRG... and it didn't work!!!
>
>Has VFP SQL a limit in number of tables or something??
>
>TIA!!