Many to many base help and linking tables

Topic Labels: Base design
916 2
Showing results for 
Search instead for 
Did you mean: 
5 - Automation Enthusiast
5 - Automation Enthusiast

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.

5 - Automation Enthusiast
5 - Automation Enthusiast

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.