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:

1. Employees - obvious
2. Documents - a list of each employee's documents
3. License Types - a list of licenses that an employee can hold
4. 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?