This is the SQL of the append query

INSERT INTO tblResults ( CaseID, Results )
SELECT tblCase.CaseID, tblResults.Results
FROM tblQuestionsAsked INNER JOIN (tblCase INNER JOIN tblResults ON
tblCase.CaseID = tblResults.CaseID) ON tblQuestionsAsked.QuestionsID =
tblResults.QuestionsID
ORDER BY tblCase.CaseID;

I have the master child fields set to CASE ID

Thanks