Skip to main content

Many to many base help and linking tables


Forum|alt.badge.img+3
  • New Participant
  • 4 replies

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.

2 replies

Alexey_Gusev
Forum|alt.badge.img+23
  • Brainy
  • 1130 replies
  • February 22, 2022

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.


Forum|alt.badge.img+3
  • Author
  • New Participant
  • 4 replies
  • February 23, 2022

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.


Reply