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).

Are we not allowed to choose two fields from one table for joins in a view?? If not, how can I accomplish what needs to be done?

Color me bummed. TIA for any assistance.

John