Entering information only once

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to create a database from a survey with numerical answers and with a
lot of rankings.

I was thinking of making a table out of each question. eg., "Rank the
following needs" is the question, and there are 9 categories that need to be
ranked. I also need to have 3 fields that are the same in each table in order
to do queries based on several different parameters.

So in order to enter the "name", "county", and "region" once and have it
show up in all the sunsequent tables that I create, what do I need to do?
 
That goes against the rules that is having the same data
in all the different tables.
Put everything in one table
or
I would but the question in one table with a key and
everyting else in another table with the question key.
 
Back
Top