I have a database that is to be used to survey different teams, using the same set of questions. I am creating a form for each question so I can store the scores, comments and evidence for each team. This is stored in several related tables (there was too much data for Access to store it all in one table), which all have a field for the team name to link them together. The form for each question will only show the info for a pre-selected team, not every answer from every team.
Also in the database, I have the questions, the criteria for each score, and the category, all in a table of their own. There is a chance that these could be re-worded over time, so I am trying to keep them in a table so it would be easy to change them once and have it update on any forms, reports etc. that they would appear on.
I am trying to get the details for each question to appear on its respective form but can't figure out how to do it. For example there is a form for question 1.1, which would display different scores, comments etc. depending on which team you are looking at, but I also want it to display the question, criteria and category for question 1.1 as held in that question's row of the questions table.
Does that make sense? Can I do that?
Also in the database, I have the questions, the criteria for each score, and the category, all in a table of their own. There is a chance that these could be re-worded over time, so I am trying to keep them in a table so it would be easy to change them once and have it update on any forms, reports etc. that they would appear on.
I am trying to get the details for each question to appear on its respective form but can't figure out how to do it. For example there is a form for question 1.1, which would display different scores, comments etc. depending on which team you are looking at, but I also want it to display the question, criteria and category for question 1.1 as held in that question's row of the questions table.
Does that make sense? Can I do that?