Show values from a related table that is related to another table
my SolveQuestion table has 3 fields, Student Names, Topics and Subject
my Mistakes Table has 2 fields: Student Name and Questions and Topics
my Topics Table has 2 fields: Topic names and Subject
SolveQuestion Table::Student Name>----<Mistakes::Student Name
Currently my SolveQuestion::Topics can show a checkbox of topic Names from valuelist configured to show related values from Mistakes Table(Related by student name)
However, i want SolveQuestions::Topics to show only topics from the specific subjects of questions that the student got wrong.
How can i do that? i don't really understand the logic of accomplishing it and can't really figure it out on my own...