Skip to main content
Question

multiple customers

  • December 9, 2020
  • 0 replies
  • 21 views

HELP!!!

I have a situation I am trying to decide what to do. 

currently have Tables

Customer
Contact
Opportunity
Opportunity Contact selection

Customer is parent to Contact
Contact is parent to Opportunity Contact Selection
Opportunity is parent to Opportunity  Contact Selection. 
Thus making Opportunity Contact selection table linked or many to many table

In my Opportunity table I have a customer field.  I would like to be able to put a customer #2 field in that I can pull another customer.  ie.  Main customer and secondary customer because sometimes we do work for a municipality directly and sometimes we do work for the municipality but it is under a General Contractor (or engineering firm)  where the General Contractor would be our customer.   I would also then like to be able to select contacts from either one of the customers. ​


Can this be done and how?

------------------------------
Tina Revermann
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
Is your issue that you have a conditional drop down to only allow selecting contacts for a company and now you have two companies?

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