Discussions

Expand all | Collapse all

3 Tables Companies, Contacts and Addresses Many to Many?

  • 1.  3 Tables Companies, Contacts and Addresses Many to Many?

    Posted 02-17-2019 16:44
    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.


  • 2.  RE: 3 Tables Companies, Contacts and Addresses Many to Many?

    Posted 02-17-2019 17:06
    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.


  • 3.  RE: 3 Tables Companies, Contacts and Addresses Many to Many?

    Posted 02-17-2019 17:32
    As usual, you are the man!  Thank you so much for your help.