Thank you for responding to my question. I not only appreciate it but I do have more tables than what was originally posted. Didn't want to bore you with details. However, now that you said more tables are needed, let me show you what I have.
Looking at all the tables you need to know this db contains 3 separate surveys that all need to be tied together via the Reservation #. Each Reservation # will complete a max of 2 surveys. PII will be completed by all and the other two will depend upon who was performing the work. All surveys are subject to change over time (ask different questions) and analysis needs to be performed for each of the 3 surveys.

tblAddreses:
ID-pk
Number
Street
City
State
Zip

tblReservation:
ReservationNo-pk
ContactLast
ContactFirst
CompanyName
ComplexName
ComplexAddressID
ContactPhone
ContractorID
ContactID

tblAnswers:
ID-pk
QuestID
QValue
Answer
SpecialID

tblSpecialInfo:
ID-pk
SpecialInfo

tblSurveyList:
ID-pk
SurveyName

tblContactPerson:
ID-pk
ContractorID
FirstName
LastName
Title
AddressID
Phone
Fax
Email

tblContractor:
ID-pk
SCNo
CoName
LicenseNo
AddressID
Phone
Fax
Email
Website

tblQuestions:
ID-pk
QuestNo
Question
AnswerID
SurveyID

tblInHouseSurveyResults:
ID-pk
ReservationNo
Lists all the responses to the survey

tblPIISurveyResults:
ID-pk
ReservationNo
Lists all the responses to the survey

tblContractorSurveyResults:
ID-pk
ReservationNo
Lists all the responses to the survey
Thank you,
Tara



John W. Vinson wrote:

You need at least a couple more tables: let us call them tblSurvey (one
19-Jan-10

You need at least a couple more tables: let us call them tblSurvey (one record
for each time a survey is filled out) and tblResponses (related one to many to
tblSurvey, who took the survey and when, and to tblQuestions, which question
is being answered).

For a fully worked out example see
Duane Hookum's "At Your Survey":
http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='At%20Your%20Survey%2 02000'

or

Roger Carlson's Training Registration database:
http://www.rogersaccesslibrary.com/d...gistration.mdb
--

John W. Vinson [MVP]

Previous Posts In This Thread:


Submitted via EggHeadCafe - Software Developer Portal of Choice
Using ASP.NET User Controls
http://www.eggheadcafe.com/tutorials...er-contro.aspx