Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Re: How to replace Join Table (from relational world)

Solved
Jump to Solution
1445 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Samir_Ghosh
7 - App Architect
7 - App Architect

I want to track Companies, People, and date each person is hired.

In a relational database I would use a “join table” to handle the many-to-many relationship and would include a “HiredDate” field in this join table.

AirTable makes many-to-many relationships easy, but then no easy way to track hire date for each person at each company. This seems like such a common use case (companies/people, products/customers, students/classes). What am I missing?

Thanks!

1 Solution

Accepted Solutions
ScottWorld
18 - Pluto
18 - Pluto

What do you mean by “track the hire date for each person”? You’re already tracking this information in the join table, but do you mean that you would like to display this information in the People table?

If so, you would use a lookup field.

Also, you might find Airtable’s guide to many-to-many relationships useful:

See Solution in Thread

2 Replies 2
ScottWorld
18 - Pluto
18 - Pluto

What do you mean by “track the hire date for each person”? You’re already tracking this information in the join table, but do you mean that you would like to display this information in the People table?

If so, you would use a lookup field.

Also, you might find Airtable’s guide to many-to-many relationships useful:

Samir_Ghosh
7 - App Architect
7 - App Architect

Thanks @ScottWorld for the prompt reply! I meant that the “hire date” is info about the relationship between company and the person. But it looks like the doc you linked has a section on “Many-to-many relationships and junction tables” which appears to be exactly my proposed use case. I’ll ping back if it does not answer my question. Thanks again!