inspection results db

[mary anne]

I've been asked to design a db to track safety inspection
results. Some of the information will be fairly
consistent (POC, Building, phone, code and description of
hazards) I can figure out how to set up tables for these.
Also, the list of inspectors will be in another table.
However, I then need a form that the inspectors will enter
a check mark for a list of items. The items are things
like hard hats, eye protection, hearing protection,
condition of signs, training, licenses updated, etc. I
also need to track the responses for each time the site
was inspected, and track the inspector. I can't figure
out an easy way to set up the tables behind this process.
Does anyone know of a sample db to guide me through this,
or can anyone suggest a fairly simple set up? Thanks

ps thanks also to whoever set up the sender e-mail default
in this discussion group. I'm sure it cuts down on the
spam generated to legitimate addresses

 

[Kevin3NF]

Sounds like you need tables for:

Inspector (obvious)
Site (thelocation being inspected)
Inspections (a table to track individual inspections at a given site)


The inspections table would have the SiteID, InspectorID, and the checkboxes
(Yes/No fields) for the items being inspected.

Make sense?

 

[mary anne]

thanks, sometimes things are a little TOO obvious!! ;-)

 

[Kevin3NF]

That's why were here

Post back when/if you need more assistance.

 

[Duane Hookom]

I would probably create a more normalized table structure that would not
contain many Yes/No fields. A more normalized approach would be similar to
the "At Your Survey" application available for study at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane