H
Howard Brody
I would have at least five tables (with the following
fields, PrimaryKeys denoted by [p]):
Set your relationships:
Hope this helps!
Howard Brody
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:
tblSeverityLevels.SeveriyLvl(one)tblAudits.BusID(many) = tblBusinesses.BusID(one)
tblAuditFindings.AuditID(many) = tblAudits.AuditID(one)
tblAuditFindings.FindingCatID(many) = tblFindingCategories.FindingCatID(one)
tblAuditFindings.SeverityLvl(many) =
Hope this helps!
Howard Brody