Hi List,



I need some help getting my head around a problem.



page1.asp is a list of questions pulled from a database (pk is 

question_id) with a yes | no radio button on the size.  I can get this to 

display correctly.



page2.asp should gather all the answers and add them to an access 

database, here is where I'm stuck.  I'm thinking the best way to store 

them is in a memo field using an array rather than a colomn for each 

yes/no value as the number of answers will change each time.  Simple 

enough to insert the array. I would just like some advice on displaying 

all this information.  So when I go in an click the questionairres ID I 

want to see a list of Questions and their relevant answers.  I can split 

the array to be 1(id)-Yes(answer) 2-No 3-Yes but i dont know how to link 

these with the questions table without a select for each question.



Any help with this would be greatful.

Thanks for reading this

Renee :)

Greetings from "sunny-one-minute, hailing-the-next" Sydney,



You already have the questions in a table (with a question ID).



Why can't you store the answer in another table with a UserID & QuestionID

as a composite primary key? That avoids storing answers a comma-delimited

text in a memo field...



Cheers

Ken



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

From: "renee" <rculley@n...>

Subject: [access_asp] Help whith Dynamic Questionairres





: I need some help getting my head around a problem.

:

: page1.asp is a list of questions pulled from a database (pk is

: question_id) with a yes | no radio button on the size.  I can get this to

: display correctly.

:

: page2.asp should gather all the answers and add them to an access

: database, here is where I'm stuck.  I'm thinking the best way to store

: them is in a memo field using an array rather than a colomn for each

: yes/no value as the number of answers will change each time.  Simple

: enough to insert the array. I would just like some advice on displaying

: all this information.  So when I go in an click the questionairres ID I

: want to see a list of Questions and their relevant answers.  I can split

: the array to be 1(id)-Yes(answer) 2-No 3-Yes but i dont know how to link

: these with the questions table without a select for each question.



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~