I am creating an applicant tool which contains the following lists:
Applicant; Applicant Answers; Job Questionnaire; Job Title
The lists are related as follows:
Applicant.ID = Applicant Answers.ApplicantID;
Applicant.JobApplicant = JobTitle.Title;
JobQuestionnaire.JobTitle = JobTitle.Title;
JobQuestionnaire.ID = Applicant Answers.QuestionID;
I need to load the questions and answers. I can load the answers from the Applicant Answer list, however, I cannot load the question text from there. Instead, I need to use the relationships listed above to retrieve the Question Text, which is a field in Job Questionnaire based on the Question ID.
I have done some research and noticed that I can't use one query to retrieve from two lists. What can I do in order to retrieve the Question Text?