访问关系问题，数据未提取到正确的表中

我的数据库似乎无法正常工作。我一路上发现的其他事情（！）中，我无法像在CLASS表中的类一样在PAYMENT表中获得考试的付款值以显示在EXAM表中。

这是Access中的关系表。

我希望它在EXAM表中显示付款，但不是，仅显示诸如此类的PAYMENT表中的条目。

这是我想要的考试的“付款”表中的值

。

I am not able to get a full SQL of the actual database from Access as it doesn't allow it, but I can get some SQL from making a query with all the tables, but be aware that I cannot program any suggestions into the database, only I can change the relationships and join types in the visual Relationships screen: pastebin.com/RS6tT8C3

SELECT 
FROM (Parent INNER JOIN Student ON Parent.[Parent ID] = Student.[Parent ID]) INNER JOIN (([Exam Type] LEFT JOIN (Exam INNER JOIN [Exam Results] ON Exam.[Exam ID] = [Exam Results].[Exam ID]) ON [Exam Type].[Exam Type ID] = Exam.[Exam Type ID]) RIGHT JOIN (([Class Type] LEFT JOIN (Class INNER JOIN Attendance ON Class.[Class ID] = Attendance.[Class ID]) ON [Class Type].[Class Type ID] = Class.[Class Type ID]) RIGHT JOIN Payment ON Class.[Class ID] = Payment.[Class ID]) ON Exam.[Exam ID] = Payment.[Exam ID]) ON (Student.[Student ID] = Payment.[Student ID]) AND (Student.[Student ID] = [Exam Results].[Student ID]) AND (Student.[Student ID] = Attendance.[Student ID]);

An extremely helpful database manager suggested to me yesterday on IRC that I should do:

payments left join exams on examid = examid left join classes classid = classid

Which I believe I was able to do by changing the join type option in the relationships tab but it didn't seem to work. I have just done 1 module of database with no SQL programming so it's been a steep learning curve!

It's gotten to a stage that everything seems too complicated and I'm losing track of things lol If anyone could give me any advice in the next few hours as I have the assignment to hand in today then it would be very appreciated. Thanks!

**I will include the full database file also.