Advice on design of a survey database

Michelangelo

Registered User.
Local time
Today, 05:20
Joined
Dec 20, 2002
Messages
37
Hi,

I'm going to design a access database with which I want to conduct a survey. The survey is about cataloging some product which are available in the market. To do this cataloging I've stated four subcategories. Now I have to give a score to every possible combination of values from those subcategories.

So for example:
Subcat1 has 6 possible values
Subcat2 has 4 possible values
Subcat3 has 10 possible values
Subcat4 has 3 possible values

Now I want to create a table in which the structure is

Field1 = Value from Subcat1
Field2 = Value from Subcat2
Field3 = Value from Subcat3
Field4 = Value from Subcat4
Field5= Score

In this table every combination of the possible values from the subcat's should be listed as seperate records so in total 6 * 4 * 10 * 3 = 720 records.

Now a complicating factor is that the number of possible values for the Subcat's aren't final. They will change, so the total number of records will change also.

My question are these:
1How to create the database so:
1. All the possible combinations of values from the subcat's are listed
2. I can add / delete / change the values of the subcat's and they will be automatically incorporated in the final scoring table. (probably something with relations)

If you have any advice on how to setup this database, please reply.

Thanx

M.
 
Check out the following attachement. Should give you a good base to start with.
 

Attachments

Users who are viewing this thread

Back
Top Bottom