G
Guest
I have been wrestling with this one for a while and can't crack it. Here goes:
I want to build a survey form which will drop results into a table. The
results will be based on facility inspections consisting of about twenty
questions for each inspection. I want to be able to generate a report based
on the inspections which will show the inspection results for a specific
room, building and inspection date. Here are the tables I have:
Questions: with fields for Question #, Question, Deficiency, Corrective
action, and Rule Citation
Survey Results: with fields for Building(lookup), Room(lookup), Inspection
Date, Question #, and Inspection Result(lookup).
I have no problems using a lookup field for building and room, but I am
having trouble using a sub-form for the survey data entry.
How do I make an inspection form which will bring up all of the survey
questions so that the building, room and inspection date only need to be
entered once for each inspection?
Any assistance will be greatly appreciated.
Mark
I want to build a survey form which will drop results into a table. The
results will be based on facility inspections consisting of about twenty
questions for each inspection. I want to be able to generate a report based
on the inspections which will show the inspection results for a specific
room, building and inspection date. Here are the tables I have:
Questions: with fields for Question #, Question, Deficiency, Corrective
action, and Rule Citation
Survey Results: with fields for Building(lookup), Room(lookup), Inspection
Date, Question #, and Inspection Result(lookup).
I have no problems using a lookup field for building and room, but I am
having trouble using a sub-form for the survey data entry.
How do I make an inspection form which will bring up all of the survey
questions so that the building, room and inspection date only need to be
entered once for each inspection?
Any assistance will be greatly appreciated.
Mark