>>I am trying to create a view using the designer in 6.0. It has three tables: ENROLL (a student's classes), SCHEDULE (the schedule data for a class), and FINAL (final grade data for a class). I need to relate these tables as follows:
>>
>>1. ENROLL.SchedFKey->SCHEDULE.PKey
>>2. ENROLL.PKey->FINAL.EnrollFKey
>>
>>If I create either join, everything is fine. As soon as I add the 2nd one, I get an error message: [ SQL: Column 'PKEY' is not found ]OR [ Column 'SCHEDFKEY' is not found ] (if I create #2, above, first).
>>
>
>This is a well-known bug in the view designer that surfaces when you try to create a view with more than one join. You can still create the view, you just have to do it with CREATE SQL VIEW. Making a view updatable and adjusting other properties without the view designer can be a pain though, but there is a tool in the files section here called eView that is designed to help you through just that.

Eric and Pascal:

I appreciate the assist. Nice to know that I am not completely nuts. I'll exlore eView as suggested. Thanks a million!

John