Thread: huge problems with database deisgn for survey
View Single Post
  #15  
Old November 20th, 2008, 02:27 PM posted to microsoft.public.access.tablesdbdesign
Desperate in Ontario[_2_]
external usenet poster
  
Posts: 8
Default huge problems with database deisgn for survey

Bumping this to the top in the hope of an answer.


"Desperate in Ontario" wrote:


This is the SQL of the append query

INSERT INTO tblResults ( CaseID, Results )
SELECT tblCase.CaseID, tblResults.Results
FROM tblQuestionsAsked INNER JOIN (tblCase INNER JOIN tblResults ON
tblCase.CaseID = tblResults.CaseID) ON tblQuestionsAsked.QuestionsID =
tblResults.QuestionsID
ORDER BY tblCase.CaseID;

I have the master child fields set to CASE ID

Thanks