Does Topics in the Mistakes table list Topic Names as does Topic Names in your Topics table?
If so, then you should be able to set up a value list that lists values from Mistakes::Topics, show only related values starting from SolveQuestion.
Hmm doesn't work... But your answer helped me simplified the problem:
I have added a Mistakes::subject field that will lookup from Topics::subject.
So now the problem is straight forward (I hope, lol):
On SolveQuestion::topics, I want to have a valuelist based on only topics from a particular subject of a particular student in Mistakes Table.
I have tried creating another table occurence of SolveQuestion (SolveQuestion 2) and relate SolveQuestion 2::subject to Mistakes::subject but the ValueList would show ALL topics from a particular subject even if they are done by different students.
Your relationship would need to match by both student and subject and a new tbale occurrence of Mistakes makes better sense than a new TO of SolveQuestion:
SolveQuestion::StudentName = Mistakes2::StudentName AND
SolveQuestion::Subject = Mistakes2::Subject
With this relationship, you can set up a value list, listing topics from Mistakes2, use only related values starting from SolveQuestion--to create your conditional value list on a SolveQuestion layout.
Final note, it would be better to use a Student ID serial number field instead of student names here. Names are not unique, may get mis-entered and in some cases may even be changed.
Again, you solved my noob problem! i can't believe that i missed out simply dragging another relationship line to link up both tables. Thanks Phil, is Filemaker paying you? If not, they ought to!