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