P
puttypapyrus
I am trying to create a database that will record survey data from
various seminars held throughout the year - just feedback based on the
specific modules that are held. The template of the survey is very
straightforward and will be applicable to every seminar.
Seminar Name
Seminar: Overall Benefit (1-5)
Seminar: Additioanl Comments
1: Overall Benefit (1-5)
Module 1: ""
Module 2: ""
and so on until the number of modules has been exhausted
However, the number of modules for every seminar will inevitably vary.
I have set up my tables in the following manner:
tblModule (contains the name of the session, associated speaker, etc.)
data)
Each entry in Module is unique and has an associated Seminar ID. Is
there any way so that I can generate a form that will automatically
create a field for each module associated with the Seminar ID (the user
inputting the data would select the Seminar Name, and a form that
mimics the suvey automatically appears)?
various seminars held throughout the year - just feedback based on the
specific modules that are held. The template of the survey is very
straightforward and will be applicable to every seminar.
Seminar Name
Seminar: Overall Benefit (1-5)
Seminar: Additioanl Comments
1: Overall Benefit (1-5)
Module 1: ""
Module 2: ""
and so on until the number of modules has been exhausted
However, the number of modules for every seminar will inevitably vary.
I have set up my tables in the following manner:
tblModule (contains the name of the session, associated speaker, etc.)
tblSpeaker (the speakers for each module)Fields: Module ID, Module Name, Speaker ID, Seminar ID
tblSeminar (the various seminars that are held throughout the year)Fields: Speaker ID, Speaker Name
tblSurvey (the table that will contain all of the general survey data)Fields: Seminar ID, Date, Seminar Name
tblSurveyModule (the table that will contain all of the module relatedSurvey ID, Seminar Name, Seminar Rating, Seminar Comments
data)
RatingSurveyModule ID, Module Name, Module Rating, Speaker Name, Speaker
Each entry in Module is unique and has an associated Seminar ID. Is
there any way so that I can generate a form that will automatically
create a field for each module associated with the Seminar ID (the user
inputting the data would select the Seminar Name, and a form that
mimics the suvey automatically appears)?