3 Tables Companies, Contacts and Addresses Many to Many?

  • 0
  • 1
  • Question
  • Updated 4 months ago
  • Answered
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.
Photo of Mark Comish

Mark Comish

  • 780 Points 500 badge 2x thumb

Posted 4 months ago

  • 0
  • 1
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.
Photo of Mark Comish

Mark Comish

  • 780 Points 500 badge 2x thumb
As usual, you are the man!  Thank you so much for your help.