Need some help figuring out correct relationships on 4 table DB

[Kev G]

Hi,

I'm working on what should be a really simple supplier audit database
and I thought I had set up the relationships OK until I started trying
to create some forms for data entry and now I'm really stumped.

Each supplier answers a bunch of audit questions belonging to a survey
(i.e. a group of questions) and I want to be able to arrange the forms
so that each supplier I can enter their audtio questions response.
Because of the way the relationships are set up I', not able to do
this on one form.
I'm hoping someone can take a look at the four tables and give me some
pointers?

tblSurvey
-------
SrvID (PK)
SrvName

tblSupplier
----------
SupplierID (PK)
SplName
bunch of other fields that describe a supplier

tblQuestions
-------------
QuestionID (PK)
SrvID (FK)
QuestionText
QuestionNumber (this for the order of each question on each survey)
QuestionType (qualifies what data type the response can be , number,
boolean freetext)

tblResponses
--------------------
SupplierID (PK)
QuestionID (PK)
ResponseNumber
ResponseBool
ResponseText

Data integrity is on and relationships look like:
1-many between tblSurvey and tblQuestions
1-many between tblQuestions and tblResponses
1-many between tblSuppliers and tblResponses

I would great appreciate any help and advice thrown my way.

Also, let me know if there is a more appropriate group I should be
pointing to?

Thanks,
Kevin

 

[Duane Hookom]

You haven't stated why you can't enter responses. Have you looked at "At Your
Survey" to see how the responses are entered?
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane