relationship multi select / search issue

  • 0
  • 1
  • Question
  • Updated 5 months 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 5 months ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,306 Points 50k badge 2x thumb
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