Structure Question

H

Howard Brody

I would have at least five tables (with the following
fields, PrimaryKeys denoted by [p]):
tblBusinesses (BusID[p], Name, Address, Contact, Etc.)
tblAudits (AuditID[p], BusID, Date, Auditor, etc.)
tblAuditFindings (AuditID, FindingCatID, SeverityLvl, Comments)
tblFindingCategories (FindingCatID[p], FindingCatDesc, Etc.)
tblSeverityLevels (SeverityLvl[p], SeverityLvlDesc, Etc.)

Set your relationships:
tblAudits.BusID(many) = tblBusinesses.BusID(one)
tblAuditFindings.AuditID(many) = tblAudits.AuditID(one)
tblAuditFindings.FindingCatID(many) = tblFindingCategories.FindingCatID(one)
tblAuditFindings.SeverityLvl(many) =
tblSeverityLevels.SeveriyLvl(one)

Hope this helps!

Howard Brody
 
J

Jaycee

Thank you!

-----Original Message-----
I would have at least five tables (with the following
fields, PrimaryKeys denoted by [p]):
tblBusinesses (BusID[p], Name, Address, Contact, Etc.)
tblAudits (AuditID[p], BusID, Date, Auditor, etc.)
tblAuditFindings (AuditID, FindingCatID, SeverityLvl, Comments)
tblFindingCategories (FindingCatID[p], FindingCatDesc, Etc.)
tblSeverityLevels (SeverityLvl[p], SeverityLvlDesc,
Etc.)

Set your relationships:
tblAudits.BusID(many) = tblBusinesses.BusID(one)
tblAuditFindings.AuditID(many) = tblAudits.AuditID(one)
tblAuditFindings.FindingCatID(many) = tblFindingCategories.FindingCatID(one)
tblAuditFindings.SeverityLvl(many) =
tblSeverityLevels.SeveriyLvl(one)

Hope this helps!

Howard Brody

-----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!
.
.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top