Discussions

Expand all | Collapse all

relationship multi select / search issue

  • 1.  relationship multi select / search issue

     
    Posted 06-12-2018 19:31
    Here's the rub....Tables: Company, Contact, BidWhen I create a new bid, I'd like to be able to search/add multiple companies that we are bidding to and bring in their info. Right now my relationship just gives me a giant list of companies which I can pick one.
    Any thoughts?


  • 2.  RE: relationship multi select / search issue

    Posted 06-12-2018 19:38
    If one company may have Many Bids and One Bid may have Many Companies, then you will need to have a "Many to Many" relationship setup. 

    To do that you need an additional  middle table called perhaps Company Bids

    So the relationship diagram would look like

    Company < Company Bids > Bids




     


  • 3.  RE: relationship multi select / search issue

     
    Posted 06-22-2018 20:23
    Thanks for that. I'll give that a shot. Have a great weekend