Autogenerating Survey Forms

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.)
Fields: Module ID, Module Name, Speaker ID, Seminar ID
tblSpeaker (the speakers for each module)
Fields: Speaker ID, Speaker Name
tblSeminar (the various seminars that are held throughout the year)
Fields: Seminar ID, Date, Seminar Name
tblSurvey (the table that will contain all of the general survey data)
Survey ID, Seminar Name, Seminar Rating, Seminar Comments
tblSurveyModule (the table that will contain all of the module related
data)
SurveyModule ID, Module Name, Module Rating, Speaker Name, Speaker
Rating

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)?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top