Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Simulate an outer join?

Topic Labels: Base design
1359 2
cancel
Showing results for 
Search instead for 
Did you mean: 
craibuc
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:

Employees

Employees.png

Documents

Docuyments.png

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
Vivid-Squid
11 - Venus
11 - Venus

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

craibuc
6 - Interface Innovator
6 - Interface Innovator

Could you elaborate on this a bit more, please?