Many to many base help and linking tables

[G_T]

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
  and
• 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?

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

[Alexey_Gusev]

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.

[G_T]

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.