Hello everyone...

I am creating a file that is for a survey we are putting out to customers. What I was thinking is to have the questions in one table as fields. So each questions will be a record in the table.

And since we are going to set it up for the user depending on what type of customer they are. (I.e. Parent, student, staff) Depending on what type they are they will be asked different questions. So I was thinking of having a field that identified the question, the question type, question sequence, etc.

So when the user enters their name, selects the type of customer they are and then clicks new survey, the correct questions will show up on the screen.

Each question has a different value list with the available answers, so I am not sure how they can be worked around either.

Does anyone have any ideas to help me put together this file for the best use.

I am up for any suggestions.

Thanks

Garry

you can have 2 tables Parent table Questions and detail/child table Answers

The parent table Questions

Qn ID (PK) | Question | Qn Type

1 actual qn| 1,2,3 parent/stdnt/staff

2 actual qn| 1,2,3 parent/stdnt/staff

3 actual qn| 1,2,3 parent/stdnt/staff

The Detail table Answers

Qn ID (FK) | Currect Answer

1 A

2 C

This is the basic Idea , can modify or include ur feilds

:

That is similar to what I had in mind, but the Answers are not really right or wrong it is a survey.

So for instance Question 1 for parent:

1.) Did you like the food?

Options - (Somewhat, Not At All, Yes, NO)

Question 1 Student:

1.) Why do you not eat at school?

Options - (To crowded, To much noise, Over priced)

Question 1 Staff:

1.) Where do you eat lunch?

Options - (Home, Classroom, Breakroom, Cafeteria)

I had the Options in value lists, I just don't know how to set the options depending on the type of question.

Thanks

Garry

See if this helps