checkbox and memo

E

Edwin Merced

How can I relate a boolean type field to a memo field.
For instance if value x field is No then query the follwing memo and if
value in y field is No query the follwing memo, etc.
 
J

John Vinson

How can I relate a boolean type field to a memo field.
For instance if value x field is No then query the follwing memo and if
value in y field is No query the follwing memo, etc.
Click to expand...

I'm sorry, this isn't making sense to me.

What's the "following memo"?
What are you "querying"?
What's the structure of your table?

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
E

Edwin Merced

OK I have 5 questions (each question field is a booleaan-Yes/No field) Each
question ,if answered with a No requieres a unique answer (the answer is
long so it must be a memo type field). Must I create a one memo field table
for each question? Or must I proceed in another way?
Each question should only respond to a unique paragraph. (that will
eventually be placed in a report) If user answers Yes no paragraph answer is
required. Look-up doent no work with memo types so hwta am I left with?
 
J

John Vinson

OK I have 5 questions (each question field is a booleaan-Yes/No field) Each
question ,if answered with a No requieres a unique answer (the answer is
long so it must be a memo type field). Must I create a one memo field table
for each question? Or must I proceed in another way?
Each question should only respond to a unique paragraph. (that will
eventually be placed in a report) If user answers Yes no paragraph answer is
required. Look-up doent no work with memo types so hwta am I left with?
Click to expand...

I would STRONGLY suggest that you normalize your table structure.
Rather than having a single record with five yes/no fields and five
memo fields, use *three* tables (or more... see below).

You have a many to many relationship between Surveys and Questions. At
the moment (and this could easily change!) each survey involves five
questions. A better design would be:

Questions
QuestionNo Integer Primary Key
Question Text

Surveys
SurveyID Autonumber Primary Key
<information about who's answering the questions, when, etc.>

Answers
SurveyID <link to Surveys>
QuestionNo <link to Questions>
Answer Yes/No
Explanation Memo

In your Form, you could then have a bit of code in the Form's
BeforeUpdate event to ensure that the Memo field is not NULL if the
Answer is NO.

You may want to see the following excellent sample survey application
developed by Duane Hookum:

http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='At Your Survey 2000'


John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Top