Skip to main content
Question

3 Tables Companies, Contacts and Addresses Many to Many?

  • February 17, 2019
  • 0 replies
  • 21 views
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.
      This topic has been closed for replies.

      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.
      Terms & ConditionsAccessibility statement