relationship multi select / search issue
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 j...
Forum Discussion
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
To do that you need an additional middle table called perhaps Company Bids
So the relationship diagram would look like
Company < Company Bids > Bids