Forms for a Checklist

[Chip]

Howdy from Oklahoma!!!, I am relatively new to ACCESS and very new to VB so
please be gentle...

Here is my situiation, I built an extremely large table to contain about 60
'yes/no' fields of an inspection checklist. I have been told that this was
wrong database archetecture of tables. Ok, i goofed up, but i was told to
create 3 tables as follows:

"tbl_FacicliyID_InspID" that has FACID and InspID as fields that would
relate a Inpestion ID# for each Inspection conducted at a facility. (each
facility will have multiple inpections)

"tbl_InspQusnID_ QusnDesc" that has InspQusnID that is an ID# for each
queation on the chaecklist and QusnDesc is the field that has the
Inspection Question text that will be shown on the form that will be
answered by the user.

"tbl_InspID_InspQusnID_Score" that has the relationship of the InspID to
the InspQusn and keeps the 'Score' (the Yes/No answer) for each question.

How do i build forms/subforms to show ALL the checklist items? I have not
been able to get
forms/subforms to show me all of the questions at the begining of inputting
a checklist, it is just showing when they are answered. I am wanting to
build queries that will pull all the negative (the questions answered "No")
trends from the checklists.

Any help would be greatly appreciated, I know I may need to post to the
Query and Forms groups for further guidance but i want to make sure i have
my tables correct or if there is a better way of doing this.

The original large table is currently working except that I cannot build a
query just pull the negitive answers (the No answers) for all the questions
of the checklist. Basically to show trends where problems are present.


As alwasys, THANKS IN ADVANCE!!!!!

 

[MacDermott]

It sounds as if you may not be populating the records in your
"tbl_InspID_InspQusnID_Score" until you record the answer.
In that case, you wouldn't be able to display the questions until you have
the answers.

If you need to display a list of questions, with no answers, you may want to
create the records for all the questions at the time you create the new
inspection. This can be a bit tricky, because you'll need to add code to
make sure extra questions are never created inadvertently.

As far as counting negative trends, you'll probably find that easiest to do
in a separate report.

Another question to consider:
Are you using the same questions in each inspection?
If not, it can become questionable to count results of different
questions.
If so, why do you need a table with the question text for each
inspection?

HTH
- Turtle