Novice QBaser...

Question

I'm struggling with building out a CRM with minimal tables.&nbsp; I have three tables...Company, Contact, Opportunity.Company has a one-to-many relationship with both Contact and Opportunity.Contact has a one-to many relationship with Opportunity.With each Opportunity, there are multiple stakeholders.&nbsp; I'd like to add those stakeholders to the Opportunity record and in some cases it might be two and in other cases it might be five.&nbsp; I cannot figure out a way to add multiple contacts to the Opportunity.I don't know if it complicates it or not, but some of the contacts might be connect to different companies.&nbsp; Here's a rough illustration:
OPPTY NAME:&nbsp; Acme Mfg&nbsp;&nbsp;&nbsp;&nbsp; VALUE:&nbsp; $32,000&nbsp;&nbsp;&nbsp; EXP CLOSE: May 2021
ACCT MGR:&nbsp; Bob Smith
SOLUTIONS:&nbsp; 20 hrs consulting, 40 hrs development, 8 hrs training, compliance reporting
STAKEHOLDERS
==============================================================
contact&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; company&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; status&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; phone&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; email
--------------------------------------------------------------------------------------------
John Doe&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ABC Consulting&nbsp;&nbsp; partner&nbsp;&nbsp;&nbsp; 205-221-2210&nbsp; &nbsp;&nbsp; jdoe@abc.com
Jane Doe&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Acme&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; client&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 205-444-1310&nbsp;&nbsp;&nbsp; jadoe@acme.com
Bill Smith&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Acme&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; client&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 205-444-1311&nbsp;&nbsp;&nbsp;&nbsp; bsmith@acme.com
Joe Smith&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Acme&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; client&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 205-441-1312&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; jsmith@acme.com
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Ken Hamm&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Deloitte&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; partner&nbsp;&nbsp; 800-877-1200&nbsp;&nbsp;&nbsp; khamm@deloitte.comIs this doable in QuickBase?&nbsp; Without adding multiple "Contact" tables?&nbsp; I just want to pull multiple contacts from multiple companies into a list associated with each opportunity.&nbsp; I want to keep all companies and contacts in a single place.------------------------------Michael Murphree------------------------------

markshnier__you · Answer

So this is a classic Many to Many Relationship.

An opportunity has many contacts but also one contact may be reused on many opportunities.

The way we do that is to have a middle table or a joint table called perhaps Opportunity Contacts.

One opportunity has many Opportunities Contacts.
One contact as many Opportunity Contacts

There will be a field to [Add Opportunity Contact] and you will put that on the Opportunity record and the Opportunity Record would also have the embedded report link field for [Opportunity contacts] with the opportunity contacts set on the form to display directly as an embedded report on the Opportunity record.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

Forum Discussion

Novice QBaser...

Related Content

Novice in need of help with rental rate formula

How to split an Export file which is too big

Galactic Appventures Now On-Demand

The field is duration but the formula returns a number result.

Re: New Forms - dynamic text

Recent Discussions

Pipeline Error --> "Quickbase reported an error: No error"

View query record if single record otherwise view query list

How do I unhide an app that I have no idea what it is named?

Gnatt plugin

Justifications for Table Report Columns