Form Problem

[tinggg]

Hi

I'm creating a database which will capture the answers to a questionaire with 25 questions.

I want to create a form that will allow me to look up Contacts, I would like to be able see all 25 questions and assign answers to these questions. I want to be able to view all the questions in this form and enter the answers there - I do not want to have to click through one question at a time - the problem to date is that I cannot get all the questions to display in this form.

Can anyone think of how I can do this? I am a basic Access user and don't have any VB so step-by-step would be greatly appreciated.

Here's some info (below) on hte structure I have used.

Thanks

I have 3 tables - Contact - Questions - Answers

1. Contacts Table

ContactID [auto number]
First Name
Last Name
etc etc

2. Questions Table

QuestionID [auto number]
Question Number (ie 1.1, .1.2, 2.1)
Question

3. Answer Table
AnswerID [auto number]
QuestionID
ContactID
Answer

I have created one to many relationships from the:
Contact table to the Answer table
ContactID to ContactID

and
I have create a one to many relationship from
Question Table to the Answer table
QuestionID to QuestionID

Creating the Form

I create a Query to create a form from
This is the structure of the query I have done using 3 tables Contact/Question/Answer:

1. Contacts table
Fields I have used = ContactID, First Name, Last Name

2. Question Table
Fields I have used = Question Number, Question

3. Answer Table
Fields I have used = Answer

Problem when I open this form I cannot see all the questions - how can I do this please?

[Horus_Kol]

sorry,
do you want to access this database through a web-form? or in Access itself?

[tinggg]

Access itself.

Thanks

[Horus_Kol]

in that case - although people round here may have an experience in Access (myself included) you may be better off trying a forum specific to Access solutions.

The problem as I see it is that you are trying to put data from more than one table into a form - and that isn't something I can come up with a quick or simple solution for.

Sorry.