Setting up a table

[jojo86]

Hi

I feel really stupid for asking this, but I am so stressed at the moment, I can't concentrate!

I have a database that stores land locations and information relating to it. In the database, I need a form that asks 13 questions and answers are given in drop down boxes (about 3 answers to each question). Each of these answers relate to a score, which I want to be able to show automatically.

What I would like to know is how to set the table for it. This table has to use the ID from the land locations table (which is sorted by the way).

Please see the attachment for a simple design of what my 'boss' wants it to look like. The form for this table will be a subform on the main form for land locations.

Please can someone help me? I would really apreciate it

 

[The_Doc_Man]

If this is a "throw-away" database, you would take one approach that tends to ignore normalization. If this is a database for long-term use, one that might change the number of questions before the database actually dies from product obsolescence, you would take a different approach that addresses normalization directly.

Please comment on your expectations of database lifetime vis-a-vis future changes.

 

[jojo86]

Its a database that is being used by my company to give to a council, so i would like it to work obviously. The number of questions will never change, neither will the answers or the scores.

Thanks for trying to help me