I am trying to create a base that tracks documentation-compliance. Essentially, I have employees that have one or more licenses, where each license requires the presence of a variety of documents to be in compliance.
I created four tables:
- Employees - obvious
- Documents - a list of each employee's documents
- License Types - a list of licenses that an employee can hold
- Document Types - a list of documents types, to be assigned to a document and required by a license
My current structure:
Employees
Documents
License Types
Document Types
What I need is a way to display (and ffilter) all employees and their documents, including a placeholder for missing documents. In this example, Jane is missing documents for both here B and C licenses.
Is this possible?