Forum Discussion

MarkComish's avatar
MarkComish
Qrew Assistant Captain
7 years ago

3 Tables Companies, Contacts and Addresses Many to Many?

I should be able to figure this out but I am just not able to think it through.  I have 3 tables I am trying to relate...

Companies
Addresses
Contacts

So Companies have many addresses - working great
Addresses have many contacts
Contacts would have 1 address

What I am trying to do is have only the related addresses for a given company show up on the contacts related company address field.

Right now every address from the address table shows up on this dropdown list.  I am guessing I need a custom record picker report or something but I just keep going around in circles.
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    7 years ago
    No problem. You need to use a conditional drop down.

    You did not state in your post whether or not you had a relationship where one company had many contacts. But you do need to set up that relationship if you don�t already have it.

    Then all you do on the field for related address on the contact record is checkbook the field properties to be conditional.

    And what you will say is once the related company is chosen for the contact then only show addresses where that field related company is equal to related company on the addresses table.
    • MarkComish's avatar
      MarkComish
      Qrew Assistant Captain
      7 years ago
      As usual, you are the man!  Thank you so much for your help.