D
Darren
I am trying to construct a database to house survey questions that are
imported via excel.
The data from excel comes with the following column headings
SurveyID Location Date Q1 Q2 ....... to Q60
My question is how to link these question answers to the actual survey
questions in another table.
My problem is that I need the structure of this table to have the following
column headings:
Question# Questiontext
Because these questions get grouped by larger measures.. ie. the first 5
questions are for one goal.
How can I link these tables without having an individual table for each
question?
Any help would be greatly apreciated.
Darren
imported via excel.
The data from excel comes with the following column headings
SurveyID Location Date Q1 Q2 ....... to Q60
My question is how to link these question answers to the actual survey
questions in another table.
My problem is that I need the structure of this table to have the following
column headings:
Question# Questiontext
Because these questions get grouped by larger measures.. ie. the first 5
questions are for one goal.
How can I link these tables without having an individual table for each
question?
Any help would be greatly apreciated.
Darren