4 Replies Latest reply on Dec 6, 2010 10:05 AM by ZhizhongNeo

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

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