C
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.
Is this the correct way to build these tables? 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.
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!!!!!
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.
Is this the correct way to build these tables? 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.
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!!!!!