relationship multi select / search issue

Question

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?

quickbasecoachd · Answer

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

jv · Answer

Thanks for that. I'll give that a shot. Have a great weekend

Forum Discussion

relationship multi select / search issue

2 Replies

Related Content

Same reference field, different selections within the form

Home Page Search Bug

Relationships functional question

Bulk create child records from selection list

Dropdown selections from app to app relationship

Recent Discussions

Filter Monthly, Quarterly, Yearly from one Date field

Extrapolating nuanced data

Forms help

Share your feedback on the new Qrew Discussions

Generating QR Code with URL to record