Simulate an outer join?

[craibuc]

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?

[Vivid-Squid]

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

[craibuc]

Could you elaborate on this a bit more, please?