AnsweredAssumed Answered

Show values from a related table that is related to another table

Question asked by ZhizhongNeo on Dec 3, 2010
Latest reply on Dec 6, 2010 by ZhizhongNeo

Title

Show values from a related table that is related to another table

Post

Hi,

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

Outcomes