Hello UT group of Gurus!!
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!!