Hi...
I've designed a few databases but am not an advanced user, and am having some trouble figuring out what Forum questions and answers relate to my problem. I've found some references to Macros and Append Queries, but I can't find any of the functions they mention in Access 2013.
This database is small and simple, logging responses from interviews. For each interview there are 18 questions, but somebody confused matters by numbering them: 1, 2, 3, 4, 5, 6, 7, 8, 9, 10.1, 10.2, 11, 12, 13, 14, 15, 16, 17. Because of this, there have been some errors in entering the proper question number and subsequent responses. I have an Interview table (InterviewID, Year, Region, Name, Facilitator), a Questions table (QuestionID, Questions), and an Answers table (ResponseID, InterviewID, QuestionID, Response). For those entering data into a form, after adding the year, region, and names I would like a subform to be automatically populated with 1) the question numbers from the Questions table and 2) blanks for their answers to be entered.
I've spent a week on this, trying out what I thought were similar inquiries in the Forum. Any help would be greatly appreciated.
Thanks!