Hi Rick,
I need to create the graph from a series of database tables. I am using
queries to pull the data from the database into a series of lists. I am
giving the key table definitions below. The database is in Microsoft
access
2003.
Note:
category is in this context are called domains.
The question stable
this is the master table that contains a list of all the questions.
question_id autoNumber primary key
question_text text, text of question
The domains table
this table contains a list of all the categories or domains.
Domain_id autoNumber, primary key
Domain_text text, description of category
the domainQuestions table
this table links the categories to the questions.
domainQuestion_id autoNumber, primary key,
Domain_id number, foreign key from the domains table
Question_id number, foreign key from the questions table
the responses table
this table records the current state. It reads responses from a Microsoft
Excel spreadsheet.
Response_id autoNumber primary key,
Question_id number, id of question from the questions table this is of
course a foreign key
Domain_id number, foreign key from the domains table
Response number, either 1 or 0 depending on whether a response is yes or
no.
yes=1 no=0.
I hope this helps.
Pranav
__________
View the list's information and change your settings at
//www.freelists.org/list/programmingblind
