relationship multi select / search issue

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered
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?
Photo of J V

J V

  • 80 Points 75 badge 2x thumb

Posted 1 year ago

  • 0
  • 1
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




 
Photo of J V

J V

  • 80 Points 75 badge 2x thumb
Thanks for that. I'll give that a shot. Have a great weekend