I have a couple of views. They are parameter views, each containing 5 tables. They execute(query) just fine. But, when trying to modify them, or load them at runtime(form data environment, nodatonload = .t.), I get SQL colum (one of the relation keys) not found.
In the development environment, a second try to run the form works, in the EXE environment, the form dies and so does the exe.
They are read-only, the calling form is to get parameters for the views, and the data is then passed to a report.
I think by creating the view at runtime, I may get around this, but as the app must be in use in 4 hours, I have little time to spare experimenting.
I hate Y2K!!!