Joins?

[Alex]

Here is my table structure:

Table1 Questionid (PK); question; testid
Table2 Answerid (PK); questionid(FK); answer; personid(FK)
Table3 Testid (PK); testname
Table4 personid (PK); personname

I want to create a form which opens all questions with
blank answer fields.

I had created a query which linked Table2 to Table1 on
questionID, pulling all questions and only those answers
that match. Then I created a form based on Table 3 and 4,
with Questions and Answers in a subform. Therefore, I
figured I could enter the answers against the questions.

However, if there is already data in Table2, then I end up
editing the pre-existing data; I want the form to always
come up blank in the answer field.

Is there a way to do this?

Any help would be wonderful,
Alex

 

[Duane Hookom]

Have you looked at how this is done in At Your Survey available at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane