Multiple Entries

[zmt-ohio]

I'm very new to this. I want to create a database of policies that will list items such as number, subject, initial effective date, last review date, department effected, lead reviewer first name and last name. Some policies will have multiple reviewers (2-8), multiple departments effected (2-5) and multiple signers (2-4). How do I keep track of those multiple items?

 

[RossWindows]

Sounds like you will need at least 7 tables.
This will allow the many-many relationships you describe:

tblPolicies
- PolicyID (pk)
- Subject
- EffDate
- RevDate

tblReviewers
- ReviewerID (pk)
- FirstName
- Lastname

tblPolicyReviewers (junction table)
- PolicyID (fk)
- ReviewerID (fk)

tblDepartments
- DeptID (pk)
- DeptName

tblPolicyDepartments (junction table)
- PolicyID (fk)
- DepartmentID (fk)

tblSigners
- SignerID (pk)
- FirstName
- LastName

tblPolicySigners (junction table)
- PolicyID (fk)
- SignerID (fk)


If the people who review are mostly the same as the people who sign, you could probably combine tblReviewers and tblSigners