-----Original Message-----
I plan to create a db to store the details of audits --
date, business area, location, etc. The part I can't
picture is how to set up fields for the audit findings.
Each finding is assigned a severity level (Level 1, Level
2, ...). There can be any number of findings, at any
level, for each audit (some, of course, will have no
findings). For example, an audit could have two Level 2
findings, one Level 3 finding, etc. The information
stored in the "finding" field will be a description of
the finding, which will vary every time (no two alike).
I may be overlooking the obvious, but how do I attach
findings to severity levels for each audit so that the
queries/reports produce accurate results?
Thanks much!
.
