i have developed a db for a survey and each question is on a new form but to associate it to the person filling out the survey you have to select their id number for every question. is there any way around this

Hopefully you have a table holding info on the person filling out your survey with a many to many relationship with your table holding survey answers.


Something like
TblSurveyedPeople
-PeopleID (Primary key)
-FirstName
-LastName
...

TblQuestionnaire
-QuestionID (primay key)
-QuestionText
...

TblSurveyAnswers
-PeoleID (foreign key)
-QuestionID(foreign key)
-Answer
...

Relationships:
TblSurveyedPeople :1____Many: TblSurveyAnswers 1:____Many: TblSurveyAnswers

Create a reports(based on surveyd people) - continuous subreport (based on SurveyAnswers) association. Parent and child fields being repectively PeopleID from TblSurveyedPeople, and PeopleID from TblSurveyAnswers.

Alex

Did you read Pat's response in your original thread? Creating new topics divides the help you can receive. Here is your original thread: http://www.access-programmers.co.uk/ubb/Forum7/HTML/002866.html

David R