Simulate an outer join?

Topic Labels: Base design
676 2
Showing results for 
Search instead for 
Did you mean: 
6 - Interface Innovator
6 - Interface Innovator

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:





License Types

License Types.pngDocument Types

Document Types.png

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?

2 Replies 2

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?