Here is a rough draft for consideration.
Try it against some test data. See what has to change.
Let us know.
Good luck.
In Questionnaire, in addition to QuestionNo, there would be a Question or QuestionText.
Moderator
Windows 10 
Access 2010 32bit
Here is a rough draft for consideration.
Try it against some test data. See what has to change.
Let us know.
Good luck.
In Questionnaire, in addition to QuestionNo, there would be a Question or QuestionText.
Competent Performer
Windows 7 64bit Access 2010 32bit
Are you saying the actual question would be in the OtherQuestInfo field as text?
Thank you very much for the help I am working on constructing it right now.
Moderator
Windows 10 Access 2010 32bit
No. Not specifically. I noticed after creating the model that I did not allow/provide a field for the actual question. {the text of the question}.
The field QuestOtherInfo was really just a way to say if you have other info related to this question you could put it here.
Sort of like -- additional info or notes.
You really have to compare/test the data model with your requirements.
Competent Performer
Windows 7 64bit Access 2010 32bit
Ok that's what I thought you meant from the beginning. was just making sure.
Table Relationships help
Table Relationships
Posting Permissions
Reply With Quote