Creating a Master Case Study and Resume Database

[Andrew_Hernande]

I tried searching the forum but could not find what I am attempting to do.

My objective is to create a Case Study and Employee Resume master database.

My goal is to be able to select an employee, select a project that the employee worked on, and then receive an output that shows that employees resume description for that project. I’m stuck on how to achieve this in Airtable.

Here are my tables so far:

Case Studies
Project Name
Client Name
Role
State
Employees that Worked on the Project
Description of Project
Role Firm Played
…

Clients
Client Name
Projects (linked)
Main Contact
Email
….

Employees
Employee Name
Title
Projects Employee Worked On (Linked)

I’m not certain how to get to the next step. Where should I store the employee’s project description when I have 65 employees? Can I do conditional formatting to be able to select what I want?

Any help would be greatly appreciate.

[ScottWorld · Accepted solution]

Welcome to the community, @Andrew_Hernandez!

You need to create another table, known as a “join table” or a “junction table”, that links to both your Employee table and your Case Studies table.

This new table acts as the intersection between Employees and Case Studies.

Each record in this table is linked to one unique employee & one unique case study — so you will have TWO linked record fields in this table. One field links to an employee, and the other field links to a case study.

It is here, within this join table, where you can type up notes for each “intersection” of employee & case study.

Hope this helps! If this answers your question, could you please mark this comment as the solution to your question? This will help other people who have a similar question. :slightly_smiling_face: