Thanks for taking the time to read my post. Apologies if this has been discussed, I have been unable to find the answer to my question.
I am trying to create an automated web form to opportunity creation with multi-level approval and acceptance by the customer with Copper CRM, which I can work through; however, I want to have sub-records of a company that can be used in the future for new opportunities.
Each company will have sub-records, that the opportunity is based on to create contracts from the information contained in the sub-record, and other information (commodity and delivery tables, which I also need to maintain in Copper).
My question is, how would I create these other sub-records that are specific to the customer?
EG: Customer Bob has five houses. Each of these houses is a sub-record of Bob. If Bob adds a new house via the webform, the 6th houses are associated with Bob's company, and a new opportunity is created.
The Opportunity calculates info from what Bob's new house record contained, as well as reference standard items from a lookup table with Copper (or elsewhere) to generate a quote for Bob.
Again, I can get my head around the automation and workflows, but lookup and linked tables and linked fields to Bob's company, I can't see them (or maybe it's a terminology issue).
I would appreciate anyone's feedback or suggestions.