Skip to main content

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?

You can use lookups with your linked records to pull that info to the Employees table.


You can use lookups with your linked records to pull that info to the Employees table.


Could you elaborate on this a bit more, please?


Reply