>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!!!

This problem is usually attributed to a bug in the view designer, but I have not seen this error at runtime. It is possible that the view designer is hosing your view so bad that it can't be opened at runtime. Try creating your view with code with CREATE SQL VIEW. (Note- this does not have to be done at runtime, doing it once at design time defines the view permanently). If your view is sufficiently complex (more than 2 tables), you will never be able to open and edit it in the view designer. I have written a freeware utility that is designed to be a repalcement for the view designer when working with complex views, you might want to give it a try. eView is available here in the files section.