N
Nancy
I am creating a database for collecting results of
inspections of my facility (a hospital). There is a fixed
list of criteria (250 different items) which are inspected
by each of about 50 departments monthly. I am trying to
create a simple form for entering the inspection results
where the full list of criteria appears will appear each
time the form is opened, with a place where the person can
indicate whether they were compliant for each of the 250
criteria. My problem in creating this form is when I link
it to the parent form which includes the department and
date; in my criteria field they need to select the
criteria rather than a whole list appearing.
In addition, if anyone has any suggestions on the most
efficient way to build this database, I'm all ears
(eyes?). I have a table for my criteria, one which
includes the dates of the inspections and where they were
conducted, then another table for the results (whether
they were compliant). I ultimately want to analyze these
results so need to collect the data in a manner in which I
can calculate complaince rates.
Thank you for any suggestions!
inspections of my facility (a hospital). There is a fixed
list of criteria (250 different items) which are inspected
by each of about 50 departments monthly. I am trying to
create a simple form for entering the inspection results
where the full list of criteria appears will appear each
time the form is opened, with a place where the person can
indicate whether they were compliant for each of the 250
criteria. My problem in creating this form is when I link
it to the parent form which includes the department and
date; in my criteria field they need to select the
criteria rather than a whole list appearing.
In addition, if anyone has any suggestions on the most
efficient way to build this database, I'm all ears
(eyes?). I have a table for my criteria, one which
includes the dates of the inspections and where they were
conducted, then another table for the results (whether
they were compliant). I ultimately want to analyze these
results so need to collect the data in a manner in which I
can calculate complaince rates.
Thank you for any suggestions!