Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Many to many base help and linking tables

Topic Labels: Base design
242 2
Showing results for 
Search instead for 
Did you mean: 

I’m working on a base to track interviews. One thing that is causing confusion is the following: when does linking tables cause issues? For instance, in the screenshot, I’m worried that structure will cause issues since:

  • company is connected to Contacts, which is also connected to Interviews
  • company is connected to Job Postings, which is also connected to interviews.

My goal is as follows, when I have an interview, I would like to add a new line item in Interview and be able to pick the contact and the job (e.g. job 123, with the VP of XYZ).

Here is what I came up with…will this cause issues? do you have suggestions?
Screen Shot 2022-02-20 at 6.38.43 PM

Thank you! This community is amazing, by the way.

2 Replies 2

Hi, it looks OK. I don’t think it should cause issues.
Here is one of my projects base (it was maintained by other person in a strange way “in any unclear situation create link or lookup” for a few years and went out of control). I did a partial cleanup and it’s working ok, but i’m still not satisfied how it looks like, and it’s not ok and can cause issues.


But yours - seems legit.

Thank you very much for the reply, @Alexey_Gusev .
I’m blown away by the base in your screenshot.
I’m also now encouraged to begin developing deeper base connections, given the caution to use lookups/rollups whenever possible. It’s nice to see a more complex sample so that I have the confidence to build up my own.

Thanks again.