Joins?

  • Thread starter Thread starter Alex
  • Start date Start date
A

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
 
Back
Top